MySQL Forums
Forum List  »  Full-Text Search

Re: Full Text Search Does Not Return Any Results
Posted by: Faury Rodriguez
Date: February 20, 2008 02:08PM

This could be due the default minimum char limit used for full text indices.
By default it is 4 and since car is 3 chars, it doesn't exist in the index.

You can check your setting with: show variables like 'ft_min_word_len';

If you'd like to search for 3 char words, you can either append a char, e.g. an underscore, to words you index and then search for +car_. Or you can do it via the instructions on if you can change the server setting.

Options: ReplyQuote

Written By
Re: Full Text Search Does Not Return Any Results
February 20, 2008 02:08PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.