Re: match by relevancy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



John Taylor-Johnston wrote:
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

Hm... You're using literal string 'johnston' for matching. Shouldn't quotes be replaced with backticks (`)?

--
Best regards,
Roman S.I.

http://sf.net/projects/naturalgine/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux