I am quite aware of a mysql mailing list. I don't feel like joining
another list,
anyway, move along,.. I've already solved the problem without your help,
but from others on this list.
John Nichel wrote:
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
