mysql使用逗号分隔的一行数据转多行数据，亲测

SELECT 
 substring_index(substring_index('1,2,3,4',',', b.help_topic_id + 1), ',', -1) result
FROM 
 mysql.help_topic b 
where 
 b.help_topic_id <  (LENGTH('1,2,3,4') - LENGTH(REPLACE('1,2,3,4', ',', '')) + 1);

实际业务，亲测

SELECT 
 substring_index(substring_index(F_DCLXBZ,',', b.help_topic_id + 1), ',', -1) F_DCLXBZ
FROM 
 mysql.help_topic b INNER JOIN (SELECT gcht.F_DCLXBZ FROM w_rygl AS ry INNER JOIN w_projectList AS gcht on ry.F_GCXM=gcht.ID_
WHERE  ry.F_XM=CAST('1789933954933981185' AS CHAR) and F_XMZT!='Completed' ) as c on b.help_topic_id<c.F_DCLXBZ
where 
 b.help_topic_id <  (LENGTH(F_DCLXBZ) - LENGTH(REPLACE(F_DCLXBZ, ',', '')) + 1);