How to find all the tables in MySQL with specific column names in them?

Solution for :How to find all the tables in MySQL with specific column names in them?

To get all tables with columns columnA or ColumnB in the database YourDatabase:

QUERY:

?

1 2 3 4

SELECT DISTINCT TABLE_NAME     FROM INFORMATION_SCHEMA.COLUMNS     WHERE COLUMN_NAME IN ('columnA','ColumnB')         AND TABLE_SCHEMA='YourDatabase';