This won't work in MySQL 4.1.10
| From: | Peter Karlsson | Date: | Wed, 27 Dec 2006 22:37:44 +0000 |
| Subject: | This won't work in MySQL 4.1.10 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42859@lists.php.net to get a copy of this message | ||
.... but it runs fine in 4.1.20. In .10 I get an error message about unknown column c. I built the sql with help from the comments from the MySQL website manual and have to admit that I don't fully understand it all ;). Is there a way to solve this without upgrading the server?
SELECT DISTINCT O.id, O.header, O.state, O.prio, O.publication_date, O.user_id, MATCH (C.body) AGAINST ('mysearch') AS relevance FROM texts AS C JOIN jobs AS O ON C.job_id=O.id WHERE O.paper_id = 1 AND MATCH (c.body) AGAINST('+mysearch' IN BOOLEAN MODE) HAVING relevance
0.2 ORDER BY relevance DESCBest regards, Peter