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]