1.确保编码是:
[mysqld] character-set-server=utf8mb4
2.确保参数 ngram_token_size=1,如果参数修改过，并且原来有全文索引，则需要执行"ALTER TABLE your_table DROP INDEX idx_fulltext, ADD FULLTEXT INDEX idx_fulltext (your_column) WITH PARSER ngram;"
3.CREATE FULLTEXT INDEX idx_fulltext ON your_table (your_column) WITH PARSER ngram;
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)