mysql 中文全文索引模糊查询和like模糊查询的速度对比

mysql 5.7以后支持中文分词全文索引

全文索引查询语句

SELECT * FROM app_list
WHERE MATCH (APPNAME,APPJIESHAO,APPJIANJIE,FULI,FANLI,WANFA,TICAI,FENLEI)
AGAINST ('历史' IN NATURAL LANGUAGE MODE) ORDER BY EDITTIME DESC

LIKE 模糊查询语句

SELECT * FROM app_list
WHERE CONCAT (APPNAME,APPJIESHAO,APPJIANJIE,FULI,FANLI,WANFA,TICAI,FENLEI) LIKE "%历史%" ORDER BY EDITTIME DESC

 

全文索引 速度是 LIKE 10倍以上