I'd like to know if it is possible to perform a search across multiple
mysql tables within a single query.
eg, i have two tables with different column names:
news: title | newstext
faqs: topic | faqstext
currently i am just searching the news table with a query as such:
SELECT *, MATCH (topic,newstext) AGAINST ('$queryword') AS score FROM news
would i have to run a second query to display results from the 'faqs' table?
thanks for any help.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
