On Thu, May 30, 2002 at 08:15:41AM -0700, Ryan Barber wrote: > 2) Why would these sample words have no match? > Cannot match against "when", "most", "like", "goes" Why are these > words not in the index? The file contains 1 million title records > and all of these words are in the file many times.
Those words are considered 'stopwords'; because they are so common, MySQL doesn't index them since (1) they won't help much in distinguishing a search query, and (2) it saves a lot of space. You can make MySQL index these words if you recompile MySQL without a stopword list. To do that, see http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html (search for the word "stopword" in that webpage). --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php