>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