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倍以上