List:General Discussion« Previous MessageNext Message »
From:A. J. Maclean Date:November 11 2002 7:15am
Subject:RE: one word fulltext matching problem...
View as plain text  
From: Jan Steinman [mailto:Jan@stripped]
Sent: Sunday, November 10, 2002 6:37 PM
To: mysql@stripped
Subject: Re: one word fulltext matching problem...

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.

--

Direct from the Manual (section 6.8):

"When MATCH() is used in a WHERE clause (see example above) the rows
returned are automatically sorted with highest relevance first."

I should add that the query word "webster" is not in more than half of the
dataset (only in 3 rows out of 18, to be exact).

Any other suggestions?

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