How to fetch data from either of tables based on input query

Asked May 10 '14 at 02:45

Active May 10 '14 at 03:03

Viewed 75 times

I had to normalize my db as it was so intense that couldn't get required search results. Now I have 10 tables and I am looking around some way that if visiter inputs query that matches with any one of 10 tables, data should be requested from that one (Anyways I have normalized it the way that query cannot be from multiple tables)

I tried:

("SELECT * FROM tb1, tb2, tb3, tb4... WHERE vbc LIKE..

That doesn't seem to work, And I guess UNION/JOINS are not worth as I want to fetch data fron either of the table. Look forward for your suggestion. Thanks.

What I have:

Table1

id  planet  areas
1   Earth   USA
2   Earth   Canada
3   Earth   Mexico
4   Earth   UK

Table2

id  Area    Flowers
1   USA     Roses
2   USA     Lily
3   USA     Lotus
4   USA     Alyssum

If only use table1, and enter 'Earth' in search I get all name of countries and if I enter 'USA' I get USA in result.. And thats what I want.. But can't seem to do it with multiple tables..

edited May 10 '14 at 03:03

asked May 10 '14 at 02:45

Sandy

It sounds like you are looking to use `Union`. Can you provide sample data and desired results? – sgeddes May 10 '14 at 02:51
If you could dump your db schema it would help – Cleric May 10 '14 at 03:02
http://stackoverflow.com/questions/7523039/mysql-query-to-search-all-tables-within-a-database-for-a-string – JD Vangsness May 10 '14 at 03:03
Hi thanks I just added further details to show you what exactly I want.. – Sandy May 10 '14 at 03:04

How to fetch data from either of tables based on input query

0 Answers0