在mysql5中,设置好了FULLTEXT类型,
SELECT * FROM `news` WHERE match (title,content) against ('you') 没结果库数据为:
id title content
1 you ,ps:me yes but ,i nod heat head.fdsaf
2 you must to .. if you want to tell me ,please .
SELECT * FROM `news` WHERE match (title,content) against ('you') 没结果库数据为:
id title content
1 you ,ps:me yes but ,i nod heat head.fdsaf
2 you must to .. if you want to tell me ,please .
总之mysql的全文索引不好用