List:General Discussion« Previous MessageNext Message »
From:Octavian Rasnita Date:November 10 2002 5:16pm
Subject:Re: one word fulltext matching problem...
View as plain text  
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



Thread
one word fulltext matching problem...A. J. Maclean10 Nov
  • Re: one word fulltext matching problem...Octavian Rasnita10 Nov
Re: one word fulltext matching problem...Jan Steinman11 Nov
  • RE: one word fulltext matching problem...A. J. Maclean11 Nov
  • Re: one word fulltext matching problem...Bjorn Palsson11 Nov