[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) √ ```