Strange issue with fulltext searching (is "self" reserved)?

[Jeremy Durham]

I have a problem with searching for a specific term. I have a database 
of about 50k names, and am attempting to search the lastname field for 
'self'. My query looks something like this:

SELECT * FROM users where MATCH (first_name, last_name) against ('self').
This query works fine if I use any other word except "self". For 
example, if I use "smith" or "johnson" I get the desired results, but 
the name self does not return any results, even though I have verified 
there are 6-7 people with the last name self in the database. Strangely, 
changing their last name to self1 or sel or anything else and then 
searching for the new term results in me locating the record. Upon 
changing the name back and rerunning the query I am unable to find them.

Is "self" a reserved word? I looked and did not find it.
FWIW I am running MySQL 4.0.18 on Debian.
Jeremy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]