Find All Tables in MySQL With Specific Column Names

by

Find All Tables in MySQL With Specific Column Names in specific schema.

SELECT 
     DISTINCT TABLE_NAME 
FROM 
     INFORMATION_SCHEMA.COLUMNS
WHERE 
      COLUMN_NAME IN ('columnName1','columnName2', columnNameN)
      AND TABLE_SCHEMA='Database Name';

Find All Tables in MySQL With Specific Column Names in all schemas.

SELECT 
     DISTINCT TABLE_NAME 
FROM 
     INFORMATION_SCHEMA.COLUMNS
WHERE 
      COLUMN_NAME IN ('columnName1','columnName2', columnNameN)