[ciapug] MySQL Fulltext searches

[carl-olsen at mchsi.com]

I'm using MySQL fulltext searching for the first time.  It works really great, but it has a couple odd behaviors that I need to deal with.  It has a stop word list, and it also creates a stop word list from the data it is indexing.  I need to be able to display a message to a user when they try to search for a stop word.  One example would be the word "Drake" when searching the Drake University news archive.  Granted, we don't want to return every record in the database, which is exactly what would happen if they typed in that word.  Is there some way I can programmatically tell if a word was not found or it was in the stop word list?

Carl Olsen
Drake University
www.drake.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/ciapug/attachments/20060913/c7f2a250/attachment.html