>From: "A. J. Maclean" <[EMAIL PROTECTED]>
>
>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> --------------------------------------------------------------------- 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
