match by relevancy
| From: | John Taylor-Johnston | Date: | Fri, 04 Nov 2005 07:03:15 +0000 |
| Subject: | match by relevancy | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-225137@lists.php.net to get a copy of this message | ||
I'm using PHP Version 4.3.9 and MySQL 4.1.12. I recently upgraded from PHP 4.1.x and MySQL 4.0.x.
Basically my SQL below now render empty set. It worked until my upgrade. Basically "ORDER BY relevancy DESC" no longer works, I think!?
I got help building this $SQL here, so I'm hoping Sgt./Corporal what's his name, who answered my original question, is still around.
Sorry to be off topic. I see no inpsiration in the relevant part of the Doc: http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html nor http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
Desperately looking for an answer. Any thoughts?
SELECT *,MATCH (AU,ST,SD)
AGAINST ('johnston' IN BOOLEAN MODE)
AS relevancy FROM ccl.ccl_main
WHERE MATCH (AU,ST,SD)
AGAINST ('johnston' IN BOOLEAN MODE)
ORDER BY relevancy DESC;
John