MySQL 字段值为多个,逗号分隔的值 作为 查询条件 IN

**

MySQL 字段值为多个,逗号分隔的值 作为 查询条件 IN

**

SELECT
    userid,
    mobile
FROM
    t_admin_user
WHERE
    userid IN (
    SELECT
    SUBSTRING_INDEX( SUBSTRING_INDEX( t.recipient_id, ',', t1.help_topic_id + 1 ), ',',- 1 )
    FROM
    t_work_message t
    JOIN mysql.help_topic AS t1 ON t1.help_topic_id < ( LENGTH( t.recipient_id ) - LENGTH( REPLACE ( t.recipient_id, ',', '' ) ) + 1 )
    WHERE
    id = #{id}
    GROUP BY
    (
    SUBSTRING_INDEX( SUBSTRING_INDEX( t.recipient_id, ',', t1.help_topic_id + 1 ), ',',- 1 )))

或者

SELECT
    userid,
    mobile
FROM
    t_admin_user
WHERE
	FIND_IN_SET(userid, (SELECT recipient_id FROM t_work_message_phase WHERE id = #{id}))