List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:November 10 2002 11:36pm
Subject:Re: one word fulltext matching problem...
View as plain text  
>From: "A. J. Maclean" <lists@stripped>
>
>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?

Without ORDER BY clause, results of a SELECT are in arbitrary order. That's just the way
SQL works --  there is no "relevance ranking" among the results.

-- 
---- SQL SQL SQL SQL SQL SQL SQL SQL  ----
: Jan Steinman -- nature Transography(TM): <http://www.Bytesmiths.com>
: Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services>
: Buy My Step Van! <http://www.Bytesmiths.com/van>
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