使用mysql语句查询数据表中某个字段是否包含某个数值的语句
SELECT * from t_person where departId like '%,132' or departId like '%,132,%' or departId like '132,%' or departId =132
这种情况下的意思为:departID中有一个是132的或者是包含132的字符串值的
另一种方法为:
select *
from t_person
where (FIND_IN_SET('48',departId) or departId in(48))
order by createTime desc
在mybatis中的写法为:
select *
from t_person
where (FIND_IN_SET(#{departID},departId) or departId in(${departId}))
order by createTime desc