UPDATE aaron a,  (SELECT     SUBSTRING_INDEX(NAME,sname,-2)    ssname   FROM (SELECT *         FROM aaron AS a,           (SELECT              CONCAT(SUBSTRING_INDEX(NAME,'||',1),'||') AS sname            FROM aaron) AS aa) AS aaa) aaaaSET a.name = aaaa.ssname去除c10-1.jpg||/c10-1.jpg||/c10-2.jpg||变为/c10-1.jpg||/c10-2.jpg||