mysql COLUMN이 포함된 테이블 검색

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('columns') AND TABLE_SCHEMA='schema name';