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]
