[Mysql实战]优化中文模糊检索

场景:
已有索引,sql语句类似如下

explain select * from users where name like '张%';

explain select * from users where name >= '张' and name < CONCAT('张', x'EFBFBF');

参考资料如下
www.cnblogs.com/sensai-sun/…