mysql search for column name in all tables

1SELECT DISTINCT TABLE_NAME, COLUMN_NAME 
2FROM INFORMATION_SCHEMA.COLUMNS
3WHERE COLUMN_NAME LIKE '%partial_column_name%'
4    AND TABLE_SCHEMA='YourDatabase';

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