MySQL Full Text Search with a short word as a keyword does not return results

Question

I want to find text 'law'in the contents of MySQL colum '(colume_name)', which matters 'this is law'. I am using this query:

SELECT * FROM `stuff` WHERE match(content) against('law' in boolean mode)

But the query above returns 0 rows. Can someone explain why there are no results?

Answer 1

You checked the system variable ft_min_word_len:? it is usually set to 4, so words with a length <4 are not included in the index FULLTEXT.

see: 11.8.6 Fine-tuning MySQL full-text search