John Taylor-Johnston wrote:
David> http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html David> Quote: David> They do not automatically sort rows in order of decreasing relevance. David> You can see this from the preceding query result: The row with the highest relevance is David> the one that contains ``MySQL'' twice, but it is listed last, not first.
Has anyone seen something like this work?
SELECT *, MATCH (ST,BT,AT) AGAINST ('margaret atwood' IN BOOLEAN MODE) AS relevancy FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret atwood' IN BOOLEAN MODE) ORDER BY relevancy DESC;
Yes.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
