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;
Thanks David.
John
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
