Sebastian wrote:
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?
http://lists.mysql.com
http://dev.mysql.com/doc/mysql/en/index.html
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
