查询语句用 FIND_IN_SET()函数:
SELECT * FROM t_userbydepartment WHERE FIND_IN_SET(departmentid,'20,168,190,181');
查询语句用 IN :
SELECT * FROM t_userbydepartment WHERE departmentid in ('20,168,190,181');
查询语句用 FIND_IN_SET()函数:
SELECT * FROM t_userbydepartment WHERE FIND_IN_SET(departmentid,'20,168,190,181');
查询语句用 IN :
SELECT * FROM t_userbydepartment WHERE departmentid in ('20,168,190,181');