searching tables
| From: | Sebastian | Date: | Mon, 23 May 2005 12:59:08 +0000 |
| Subject: | searching tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215736@lists.php.net to get a copy of this message | ||
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.