|
Posted by John Nichel on 05/23/05 17:11
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@kegworks.com
Navigation:
[Reply to this message]
|