From: Jan Steinman Date: November 10 2002 11:36pm Subject: Re: one word fulltext matching problem... List-Archive: http://lists.mysql.com/mysql/124588 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "A. J. Maclean" > >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): : Bytesmiths -- artists' services: : Buy My Step Van!