MYSQL Match示例不起作用。 “Spa”是一个禁区吗？

Question

SELECT * FROM mytable WHERE match(fieldname) against('spa')

I don't understand why this query doesn't return any results. It should find at least 10 rows with the word spa in. Spa isn't a keyword/stop word is it?

Answer 1

The minimum and maximum lengths of words to be indexed are defined by the ft_min_word_len and ft_max_word_len system variables. The default minimum value is four characters; the default maximum is version dependent. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes. Note particularly the remarks regarding myisamchk in the instructions following this list.

Source: http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html