Given a column name how can I find which tables in database contain that column?

Question

• Given a column name how can I find which tables in database contain that column ?

  or alternatively

• How can I find that particular column exists for all tables in Database ?

Note: Kindly explain answers with Examples as that I get most knowledge from the answer.

Edit: I am using MySQL Database.

Answer 1

SELECT * FROM information_schema.columns WHERE COLUMN_NAME = 'mycolumn'