relevance with complex fulltext query

[leegold]

I want to have the query cited at the very bottom return a result sorted
by FullText Relevance. I'm thinking I would modify each SELECT
separately. For example maybe the first SELECT clause something like:

SELECT page.* FROM `page` LEFT JOIN `keywords`  USING (`page_id`), MATCH
(`keywords`.`keyword_txt`)AGAINST ('$radio_keyword' IN BOOLEAN MODE) as
RELEVANCE FROM `page` WHERE MATCH (`keywords`.`keyword_txt`)AGAINST
('$radio_keyword' IN BOOLEAN MODE) 

and then the same idea for the other two (2) SELECT clauses(?) I'm not
sure...here's the MYSQL (and php) query in question. Any help
appreciated:

     $query =
       "SELECT page.* FROM `page` LEFT JOIN `keywords`  USING
       (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`)AGAINST
       ('$radio_keyword' IN BOOLEAN MODE)
       UNION
       SELECT page.* FROM `page` WHERE MATCH (`title`, `descrip`)
       AGAINST ('$radio_keyword' IN BOOLEAN MODE)
       UNION
       SELECT page.* FROM `page` LEFT JOIN `url_pages` USING (`page_id`)
       WHERE MATCH (`url_pages`.`page_url`) AGAINST ('$radio_keyword' IN
       BOOLEAN MODE)";

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]