[toc] ## 创建全文索引 ```mysql create fulltext index `title1` on fa_pan_topic(`title`,`desc`,tag) with parser ngram; create fulltext index `title` on fa_pan_topic(`title`) with parser ngram; ``` - `ngram` 插件支持中文搜索,表结构可能出现`/*!50100 WITH PARSER ``ngram`` */` 注释,是正常的,请参考[mysql /*! 50100 ... */ 条件编译](https://www.cnblogs.com/ClassNotFoundException/p/8475445.html) - 为什么重复建`title`和`title1`索引,答:为防止出现`Can't find FULLTEXT index matching the column list` ## 常见问题解决办法 ### 1、1191 - Can't find FULLTEXT index matching the column list [Can't find FULLTEXT index matching the column list Error Coming When i am trying to do a full text search \[duplicate\]](https://stackoverflow.com/questions/25301267/1191-cant-find-fulltext-index-matching-the-column-list-error-coming-when-i-a) ### 2、SQLSTATE[HY000]: General error: 1210 Incorrect arguments to MATCH 每张表的全文搜索单独分开,用`or`关联 ```sql MATCH(a.title, b.title) AGAINST('贵阳', IN BOOLEAN MODE) × MATCH(a.title) AGAINST('贵阳', IN BOOLEAN MODE) OR MATCH(b.title) AGAINST('贵阳', IN BOOLEAN MODE) √ ```