SELECT GROUP_CONCAT(b.name
) name FROM erp_sys_auditdetails
a
LEFT JOIN erp_sys_employe b ON FIND_IN_SET(b.id,a.down_auditor) WHERE a.id=6
mysql 逗号分隔的id转为逗号分隔的名称
最新推荐文章于 2023-05-19 14:05:12 发布
SELECT GROUP_CONCAT(b.name
) name FROM erp_sys_auditdetails
a
LEFT JOIN erp_sys_employe b ON FIND_IN_SET(b.id,a.down_auditor) WHERE a.id=6