I have a query regarding mysql and PHP ... here it is .... I know there is a field data exisiting in one of the tables in the present database; I want to know whether there is any sql or PHP function with which I can find out in which table the field data is present for example ..... I have database called asset in which 5 table are present namely asset1,asset2,asset3,asset4,asset5... all the tables have the same schema structure and common field names ,equal no of columns(but not the equal number of rows) I want to know ,in which table among the above is having a particular field data for example ...the column name is asset_loc ( common for all the tables,but no constraints ,no relation with other tables) I want to know if the asset_loc from any table has the data 'heaven' it should be something like this select * from asset1,asset2,asset3,asset4,asset5 where asset_loc='heaven'; Thanks, waiting for a quick response ....from a great list. SELECT * FROM Linux_kids where Dis_Hard_Fans='Nikhil' ;-)
