MySql查询优化

 

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))