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 worked until my upgrade. "ORDER BY relevancy DESC" no longer works? 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; I see no inpsiration in the relevant part of the Docs: 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? John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]