Is this possible? Is it possible to have three queries in a UNION? Sorry
about the PHP in there. I just wanted to know if this is allowed? If
only the 1st two queries it works OK, add the 3rd and it breaks. How can
I accomplish this? Thanks. Lee G. I'm using 4.1.3beta
$result = mysql_query("(SELECT p.page_id, p.page_url AS url, p.title AS
title,
p.descrip AS descrip
FROM page p, word w, occurrence o
WHERE p.page_id = o.page_id AND
w.word_id = o.word_id AND
w.word_word LIKE '%$keyword%')
UNION
(SELECT p.page_id, p.page_url AS url, p.title AS
title,
p.descrip AS descrip
FROM page p
WHERE p.descrip LIKE '%$keyword%' OR
p.title LIKE '%$keyword%')
UNION
(SELECT p.page_id, p.page_url AS url, p.title AS
title,
p.descrip AS descrip
FROM url_pages u
WHERE u.page_url LIKE '%$keyword%')");
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
