记录一下Mysql模糊查询

一、使用LOCATE查询

EXPLAIN SELECT * from ecs_goods  WHERE LOCATE('CICI0001',goods_sn)>0;

二、使用LIKE ‘%CICI0001%’查询

EXPLAIN SELECT * from ecs_goods  WHERE goods_sn like '%CICI0001%';

EXPLAIN SELECT * from ecs_goods  WHERE goods_sn like CONCAT('%','CICI0001','%') 

 

 

三、使用LIKE ‘%CICI0001’

EXPLAIN SELECT * from ecs_goods  WHERE goods_sn like '%CICI0001';

四、使用LIKE 'CICI0001%'查询

EXPLAIN SELECT * from ecs_goods  WHERE goods_sn like 'CICI0001%';

---

从上面可以看出只有第四种情况走了索引。