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: orasnita@stripped
----- Original Message -----
From: "A. J. Maclean" <lists@stripped>
To: "MySQL List" <mysql@stripped>
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 <mysql-thread124561@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-orasnita=home.ro@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
