CODEWITHSUNDEEP
mysqlfull-text-search
Essam Elmasry
Essam Elmasry

Reputation: 1252

match() against() doesn't work all the time


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?

Upvotes: 1

Views: 178

Answers (1)

Mihai
Mihai

Reputation: 26784

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

Upvotes: 1

Related Questions