How to fetch records from database all tables accoring to searchstring which i will enter in a text box

[manu chowdry]

I m using php & mysql 5 version
I want to make a script,,,
I have a text box & a button named search

When i click on search button i want it will search the string that i have entered in text box in whole database means in all tables of my innodb database tables. & show result according to search string.

Show the records that match the searchstring.

How can i do this.



1) The tables r related - i.e a join can be implemented across the individual tables ?
2) I need to search all columns of all tables of database ?
3) Show the records,, But problem is that fields are different in all tables
4) Field name in all tables r different
5) I m using INNODB