mysql 模糊查询实现

EXPLAIN SELECT * FROM `text` WHERE content like '%1%3%';
EXPLAIN SELECT * FROM `text` WHERE locate("1",content)>0 and locate("3",SUBSTRING(content,locate("1",content)))>0

都可以达到效果