Mysql FIND_IN_SET
FIND_IN_SET(str,strlist)
str 要查询的字符串
strlist 字段名 参数以”,”分隔,如:2,3,4,5,1
查询字段(strlist)中包含(str)的结果,返回结果为null或记录
如下SQL会返回多条记录:
select * from table where FIND_IN_SET(id, '2,3,4,5,1');
有点类似in (集合)
select * from table where id in (2,3,4,5,1);
项目真实案例
SELECT * FROM je_core_department WHERE FIND_IN_SET(DEPTID,REPLACE((SELECT PATH from je_core_department WHERE DEPTID = "00bwaiu8NkNaT6quYI6"),"/",","));