From: Jan Steinman [mailto:Jan@;Bytesmiths.com] Sent: Sunday, November 10, 2002 6:37 PM To: [EMAIL PROTECTED] 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? --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
