SUBSTRING_INDEX（），字符串截取，一行拆分多行。

表名：res_area

拆分前：

拆分后：

SQL语句：
SELECT id,SUBSTRING_INDEX( SUBSTRING_INDEX( a.contains_community_names, ‘,’, b.help_topic_id + 1 ), ‘,’,- 1 ) AS committees_name
FROM res_area AS a JOIN mysql.help_topic AS b ON b.help_topic_id < ( length( a.contains_community_names ) - length( REPLACE ( a.contains_community_names, ‘,’, ‘’ ) ) + 1 )
where a.id = ‘11efacfeeffc41d491860fee3fb1aa6f’