Hi! On Mar 09, Shawn wrote: > In http://www.databasejournal.com/features/mysql/ they give an example > of a BOOLEAN MODE search using "here" which they also pointed out was a > stop word in regular full text searches. > > mysql> SELECT copy, MATCH(copy) > AGAINST ('+here past' IN BOOLEAN MODE) > AS m FROM fulltext_sample WHERE MATCH(copy) > AGAINST ('+here past' IN BOOLEAN MODE); > > I wonder if that means stop words are not used for boolean mode > searches??? I need to search for a whole host of those stupid little > words so this makes a difference to me.
I cannot say what it was supposed to mean :) But for now stop words ARE used for boolean searches too. > Also, what is meant by rebuild the indexes?? (to change the STOP list). > Stupid q I know, but not having build mysql, I can't tell if rebuilding > the indexes is an actual step that would need to be performed beyond > editing the file and recompiling. "rebuild the indexes" means, e.g. REPAIR TABLE ttt QUICK; it's the fastest way. Sometimes REPAIR TABLE ... USE_FRM is necessary, but these cases are always explicitly indicated in the manual. > Directions I can't fully understand----> > You'll need to edit the file myisam/ft_static.c. recompile MySQL, and > rebuild the indexes! You don't have to understand it anymore - this clause was removed from the manual. Check the latest manual on http://www.mysql.com/ (and upgrade). Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
