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
Others have already pointed out a couple reasons this might not work.
Do I understand correctly that you have a full-text index on a single column which holds a single name per row? If so, my question is, why are using a full-text index? They aren't really designed for that situation. In other words, why not simply do
SELECT * FROM students WHERE first_name = 'May';
and just put a regular index on first_name?
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
