>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>
