* Joao Verde > The problem is I cannot search for one specific word because, even > though the word exists on several records, MySQL never returns any > rows. > > The word I can't look for is "portaria". Any other word works just > fine. I have tried every word I could think of and it works... except > for that one: "portaria".
Is this word very common in the table? Are you using IN BOOLEAN MODE? If more than 50% of the rows contains this word, it is ignored in a fulltext search unless IN BOOLEAN MODE is used. You can also disable the 50% treshold by recompiling the server: <URL: http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html > -- Roger query --------------------------------------------------------------------- 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