match()对()不会一直工作 [英] match() against() doesn't work all the time
问题描述
所以我试着这个简单的查询: http://sqlfiddle.com/# !2 / f3c5e / 2
全文检索可以处理某些字词,但不会与其他字词一起使用。
工作单词: eeeee
Godgo
- t工作:说
锯了
有人可以告诉我这种不同行为的原因吗?
innodb_ft_min_token_size和innodb_ft_max_token_size用于InnoDB
搜索索引,ft_min_word_len和ft_max_word_len用于MyISAM
。
http://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean .html
最小默认长度是4我认为
so I was trying this simple query : http://sqlfiddle.com/#!2/f3c5e/2
full text search does work with some words but doesn't with others .
words that work : eeeee
Godgo
words that doesn't work : Said
saw
can someone tell me the reason for this different behavior?
the minimum and maximum word length full-text parameters apply: innodb_ft_min_token_size and innodb_ft_max_token_size for InnoDB search indexes, and ft_min_word_len and ft_max_word_len for MyISAM ones.
http://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html
The minimum default length is 4 i think
这篇关于match()对()不会一直工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!