How to find out what tables in a MySQL database have a specific column, by name.

SELECT DISTINCT TABLE_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('<col name>')
    -- could also do COLUMN_NAME LIKE '%<col name>%'
        AND TABLE_SCHEMA='<db name>';