MySQL 全文检索设置停止词

MyISAM 存储引擎

查看全文检索配置

SHOW VARIABLES LIKE 'ft%';

输出

ft_stopword_file为MyISAM存储引擎的停止词配置文件

SET ft_stopword_file="/home/mysql/stopword.txt";

InnoDB 存储引擎

查看ngram如何标记文本

SET GLOBAL innodb_ft_aux_table="z-blog/post";

SELECT 
    *
FROM
    information_schema.innodb_ft_index_cache
ORDER BY doc_id , position;

参考文档

https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html#fulltext-stopwords-stopwords-for-myisam-search-indexes