Hi, If 'webster' can be found in more than a half of the records from the database, it is considered a stop word and it is ignored.
The solution is to force searching for that word by placing a '+' sign before it like '+webster' I guess this should be the problem, but if it is not the case, ... sorry. I've started learning MySQL only for 3 days. Cheers. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] ----- Original Message ----- From: "A. J. Maclean" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, November 10, 2002 1:16 PM Subject: one word fulltext matching problem... I have a query like this: SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details, post_message) AGAINST ('webster'); I get the results as follows: webster hall webster webster hall club How come the exact match (i.e. "webster") does not get a higher relevance? I remember seeing some kind of workaround for this problem, but I can not for the life of me find it anymore!! TIA, AJ --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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