Sergei Golubchik wrote: > On Feb 28, David yahoo wrote: > > SELECT * FROM T_Stories WHERE match .... against ('+fiat -bagnole' IN > > BOOLEAN MODE) > > doesnt give any row > > but when changing fiat to fiato it gives me row ? > > may be there're no rows with "fiat" ? :)
Or maybe there are too many. It appears that any word that appears in more than half the rows is treated as a stop word: http://www.mysql.com/doc/F/u/Fulltext_Search.html -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- 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