Query multiple tables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Extremest
Forum Commoner
Posts: 84
Joined: Mon Aug 29, 2005 12:39 pm

Query multiple tables

Post by Extremest »

Is there a way I can query multiple tables with a fulltext search and get the results back in a normal rowset.
Each table has the exact same fields just different data. Would like to search all of them at once and get one dataset instead of it adding each table to the right of the last one. Kinda like it made the 2 tables 1 table just for the search.
User avatar
wtf
Forum Contributor
Posts: 331
Joined: Thu Nov 03, 2005 5:27 pm

Post by wtf »

ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

If your using MyISAM tables this is your best bet:

http://dev.mysql.com/doc/refman/5.0/en/ ... ngine.html
Post Reply