From: Jan Steinman [mailto:Jan@stripped]
Sent: Sunday, November 10, 2002 6:37 PM
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
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?