selecting all tables in my db
-
Hey, First I couldnt find a direct database forum, but i am using asp.net, so here it goes. I am creating a search function, and I want to search all tables in my mysql db. Now I have researched and found that this can be done simply by seperating all the tables in the FROM clause with commas, or using a UNION statement, but what I want to know is can you just select all of the tables in the db at once? All my tables are identicle in structure, and at first i would just like to search the one field from each table. I have tried using something like "SELECT * FROM *" but i get errors. The main reason I want to do this is because everytime I add a table in the db I dont want to have to edit the code. If anyone can help or even point me in direction of some good articles it would be appreciated. Thanks for your time.