摘要：
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||变为/... 阅读全文