高效的 like 查询mysql

 

 

SELECT `title` FROM `phome_ecms_news` WHERE LOCATE('中国古代', `title`)>0

 

SELECT `title` FROM `phome_ecms_news` WHERE POSITION('中国古代' IN `title`)

 

自己项目用到