Unanswered: select query to find the particular column in the database
I have yearmonth column in more than 50 tables in the customers database. I have to find the what are all the tables are having yearmonth column from the customers data base.
Please provide the select query.Thanks
from information_schema.COLUMNS c,
where c.table_schema = "customers"
and t.table_schema = "customers"
and t.table_type = "BASE TABLE"
and c.table_name = t.table_name
and c.column_name = "yearmonth";