select FIND_IN_SET(str,strlist)
-- FIND_IN_SET函数返回的是str在strlist中返回的存在位置,不存在返回0
-- strlist是由','连接的字符串,如下:
select FIND_IN_SET(1,"6,1,2,3,1,5,1,8") -- 2
select FIND_IN_SET(9,"6,1,2,3,1,5,1,8") -- 0
select * from t_settlement_bag where FIND_IN_SET(1,"1,2,3,1") -- 可以查询到数据
select * from t_settlement_bag where FIND_IN_SET(6,"1,2,3,1") -- 查询不到数据