the ft_min_word_length is now set to 3. That did the trick. Many thanks.
I forgot to mention that I need to be able to perform boolean searches on the first_name field.
If it's possible to do boolean searching on a normal index, should I be doing that instead of using a fullttext?
Thanks for the help! Ari
On Sep 6, 2004, at 2:26 AM, Thomas Spahni wrote:
Ari, what's the result of
mysql -N -e "SHOW VARIABLES;" | grep 'ft_min_word_len'
? Default is 4 but you need to reduce this to 3 (or even to 2, if you want to match first_name against('Al')).
Regards, Thomas Spahni
On Sun, 5 Sep 2004, Ari Denison wrote:
Hello list - I'm trying to do a full text search for the the string "May" using the following query:
SELECT * FROM students WHERE MATCH(first_name) AGAINST("May");
There are a number of students in that table wit the first_name of May.
And, yes, I've removed may from the stopwords list and have reindexed
the field but still return no records.
Any idea how to get my May students to show in full text search results?
Thanks, Ari Denison
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]