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.
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.
Directions I can't fully understand---->
You'll need to edit the file myisam/ft_static.c. recompile MySQL, and
rebuild the indexes!
TIA,
--
Shawn <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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
