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.
Query multiple tables
Moderator: General Moderators
I'd start here
http://dev.mysql.com/doc/refman/4.1/en/union.html
http://dev.mysql.com/doc/refman/4.1/en/union.html
If your using MyISAM tables this is your best bet:
http://dev.mysql.com/doc/refman/5.0/en/ ... ngine.html
http://dev.mysql.com/doc/refman/5.0/en/ ... ngine.html