Find All Tables in MySQL With Specific Column Names

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';

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

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.