mysql优化查询【持续增补】

例1.用户名搜索
配置mysql

[mysqld]
ngram_token_size = 1  # 按单字符分词

然后增加全文索引

ALTER TABLE user ADD FULLTEXT INDEX idx_nickname_fulltext (userNickName) WITH PARSER ngram;

然后使用MATCH AGAINST

SELECT * FROM user WHERE MATCH(userNickName) AGAINST(CONCAT('"', #{nickName}, '"') IN BOOLEAN MODE);