Thanks Philip, I spent some time looking for that list, but obviously didn't look hard enuf.
Ryan > > 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