MySQL Lists are EOL. Please join:

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  

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.

Teddy's Center:
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 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!!



Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread124561@stripped>
To unsubscribe, e-mail <>
Trouble unsubscribing? Try:

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