mysql中in条件使用字符串方式

select id,name from user where id in(?)

select id,name from user where FIND_IN_SET(id,#{strlist})

select id,name from user where FIND_IN_SET(id,'111,22,333')

SELECT
  (
    SELECT
      GROUP_CONCAT(content)
    FROM
      account_limit_user ur
    WHERE
      ur.id IN (T1.limit_user)
    GROUP BY
      ur.id
  ) AS limit_user
FROM
  account T1
WHERE
  1 = 1

CAST('4,3' AS INT)

FIND_IN_SET('查询的值（如:1）', '使用逗号隔开的字符串集合，如:（'1,2,3'）')

SELECT
  (
    SELECT
      GROUP_CONCAT(content)
    FROM
      account_limit_user ur
    WHERE
      FIND_IN_SET(ur.id, T1.limit_user) > 0
  ) AS limit_user,
  T1.limit_user limit_userid
FROM
  account T1
WHERE
  1 = 1