List the table's that has same column

[maheswaran]

Hi all,

i want list tables from a database that has one particular column. Like

Table 1

id, name

Table 2

DOB, Age

Table 3

id, address

In these three tables i want to list the table that have the column id like ans table 1, table 2...

How can i?

[mwasif]

You can achieve this with the help of INFORMATION_SCH EMA Tables, but you need to have MySQL 5.

[maheswaran]

thanks wasif , link have good instructions, will try

[mwasif]

You are welcome!