字段flIds在数据库中存储的字段如下
记录1:9,10,12,14,15,16,17,18,19,20,21,22
记录2:10,12,14,15,16,17,18,19,20,21,22
现在要查询flIds为9的记录
select * from tableName where flIds like '%9%'
这样查询出的结果会包含记录1和记录2
找出统一规律应该这样去查询like '%,9,%'
但是开始和结束不包含,这样会漏掉相关记录,应该先对flIds字段进行修改在查询
SELECT * FROM tableName WHERE INSTR(CONCAT(",",flIds,","), ',9,');