UPDATE 需要修改的表 k1,
( SELECT id,GROUP_CONCAT(`Name` SEPARATOR ',') NAMES
FROM (SELECT DISTINCT a.id,
SUBSTRING_INDEX( SUBSTRING_INDEX( a.需要修改的字段,',', b.help_topic_id + 1 ), ',',- 1) NAME
FROM 需要修改的表 a JOIN mysql.help_topic b
ON b.help_topic_id < ( LENGTH( a.需要修改的字段 ) - LENGTH( REPLACE ( a.BUSINESS_TYPE, ',', '' ) ) + 1) ORDER BY a.id) aaa
GROUP BY id) k2
SET k1.需要修改的字段 = k2.NAMES
WHERE k1.id = k2.id
转载于:https://blog.csdn.net/weixin_39584571/article/details/111546656