需求:项目表里有成员成员id字段,成员id以“,”隔开,现需要根据这些成员id转化成对应的名字
sql:
SELECT USER_ID,SEX,NAME FROM user where USER_ID in (
SELECT
SUBSTRING_INDEX( SUBSTRING_INDEX( p.MEMBER_ID, ',', b.help_topic_id + 1 ), ',',- 1 ) AS ids
FROM project p JOIN mysql.help_topic AS b ON b.help_topic_id < ( length( p.MEMBER_ID ) - length( REPLACE ( p.MEMBER_ID, ',', '' ) ) + 1 )
WHERE p.PROJECT_ID = 3);
效果截图:
项目对应的成员:
执行后效果: