1.模糊查找,中间有逗号分隔
SELECT * from d_tag where FIND_IN_SET(2,tag_id)
-------------
SELECT
*
from
d_tag
where
-- CONCAT_WS (tag_id,1,2,3,4)
(FIND_IN_SET('1',tag_id) or FIND_IN_SET('2',tag_id) or FIND_IN_SET('33',tag_id))
1.模糊查找,中间有逗号分隔
SELECT * from d_tag where FIND_IN_SET(2,tag_id)
-------------
SELECT
*
from
d_tag
where
-- CONCAT_WS (tag_id,1,2,3,4)
(FIND_IN_SET('1',tag_id) or FIND_IN_SET('2',tag_id) or FIND_IN_SET('33',tag_id))