我有一个场景，我需要搜索一个特定的字符串使用FULLTEXT搜索。
要搜索的字符串为：
rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrffffffffffffffffffffffffffffffffffffffffffffffffttttttttttttttttttttttttttttttttttttttuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii查询是
SELECT * FROM TABLE_NAME t1 WHERE (MATCH(t1.Name) AGAINST('rrr*' IN BOOLEAN MODE))MySQL FULLTEXT Search有什么限制吗？
1条答案
按热度按时间ehxuflar1#
正如mysql manual on boolean fulltext search所指出的，最小和最大令牌大小限制都适用于这样的srarch：
最小和最大字长全文参数适用于使用内置FULLTEXT解析器和MeCab解析器插件创建的FULLTEXT索引。innodb_ft_min_token_size和innodb_ft_max_token_size用于InnoDB搜索索引。ft_min_word_len和ft_max_word_len用于MyISAM搜索索引。
最大令牌大小的默认值为84。