Re: Full Text Search Does Not Return Any Results
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
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html if you can change the server setting.
Subject
Views
Written By
Posted
7757
February 19, 2008 02:39PM
Re: Full Text Search Does Not Return Any Results
4725
February 20, 2008 02:08PM
3794
February 21, 2008 01:33PM
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.