Bulk update comma-separated names (in department, convert multiple comma-separated IDs into comma-separated names) (MySQL)

Update Dept B, (select Group_concat (T.deptid), Group_concat (d.deptname separator '/') as Dname, T.id, t.deptname from (sel ECT Substring_index (Substring_index (A.deptid, ', ', b.help_topic_id+1), ', ', -1) as DeptID, a.ID, A.deptname
From
(select D.father as DeptID, D.id, D.deptname
From Dept D) a
Join Mysql.help_topic B on b.help_topic_id < (length (A.deptid)-Length (replace (A.deptid, ', ', ')) +1) T left JOIN Dept D on t.deptid = d.id where t.deptid! = "

GROUP by ID, deptname) C set b.location=c.dname where b.id = C.id

Effect

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Bulk update comma-separated names (in department, convert multiple comma-separated IDs into comma-separated names) (MySQL)