MySQL: Select all tables that has a column with name

How to select all tables that has a column / columns:

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN (‘column1′,’column2′) AND TABLE_SCHEMA=’database_name’;