CODEWITHSUNDEEP
mysqlfull-text-search
user75472
user75472

Reputation: 1295

how do I fix full text search for 3 characters?

I have used full text search mysql. My code is select * from uh_property WHERE match(fieldname) against('serach_word')

Now when i type word of three character search record is not displayed. For example i have record with name 'eco'. When i type eco in text box for search no record displayed.

I found that minimum character for full text search is 4. Is there anyway to solve this problem?

Upvotes: 1

Views: 3813

Answers (1)

Yuval F
Yuval F

Reputation: 20621

Please see Fine-Tuning MySQL Full-Text Search. You first need to change ft_min_word_len (or innodb_ft_min_token_size for InnoDB tables) and then rebuild the fulltext search indexes.

Upvotes: 4

Related Questions