MySQL - Find What Tables Have a Column Name

January 31, 2024 note-to-self

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=(SELECT DATABASE())
        ;

These posts are for my own understanding. Reader beware. Info may be wrong but it reflects my current understanding.