problem full text search in mysql

Question

I want to search a text 'law' in the Mysql colume 'content(colume_name)' thats values is('this is law') I am using this query SELECT * FROM stuff WHERE match(content) against('law' in boolean mode)

But this query returns 0 rows

Thanks

Answer 1

did you check the system variable: ft_min_word_len? ususally it's set to 4, so words with length < 4 are not included in the FULLTEXT index.

see: 11.8.6 Fine-Tuning MySQL Full-Text Search