search_for_column_name_databasewide.sql

-- MySQL

-- Search all tables, databse-wide, for a column name.
-- EXACT MATCH
SELECT DISTINCT TABLE_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('col_name')
        AND TABLE_SCHEMA='db_name';

-- PARTIAL MATCH
SELECT DISTINCT TABLE_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME LIKE ('%partial_name%')
        AND TABLE_SCHEMA='db_name';