I have created full text search in my database
its showing wrong result for in Boolean mode search
SELECT * FROM catalgo_auto_productdetails WHERE product_name like '%htc%'
showing correct result
SELECT * FROM catalgo_auto_productdetails WHERE MATCH (`product_name`)
AGAINST ('htc' IN BOOLEAN MODE)
showing empty result
As documented under Fine-Tuning MySQL Full-Text Search:
The minimum and maximum lengths of words to be indexed are defined by the
innodb_ft_min_token_size
andinnodb_ft_max_token_size
forInnoDB
search indexes, andft_min_word_len
andft_max_word_len
forMyISAM
ones. After changing any of these options, rebuild yourFULLTEXT
indexes for the change to take effect. For example, to make two-character words searchable, you could put the following lines in an option file:[mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2Then restart the server and rebuild your
FULLTEXT
indexes. ForMyISAM
tables, note particularly the remarks regarding myisamchk in the instructions following this list.