mysql 全文索引


mysql5.7 +

 

ALTER TABLE `news`
DROP INDEX `Title` ,
ADD FULLTEXT INDEX `Title` (`Title`, `Content`, `KeyWords`) WITH PARSER ngram;

 

select *  from news where MATCH (title,keywords, content) AGAINST ('银川'  WITH QUERY EXPANSION);​


豫ICP备12024565号-1   E-mail:admin@hlc8.com