On gists

Find column name in database

MySql

find-column.sql Raw #

SELECT 
    table_name, 
    column_name, 
    data_type,
    ordinal_position

FROM  INFORMATION_SCHEMA.COLUMNS 

WHERE TABLE_SCHEMA = 'database-name'     
AND COLUMN_NAME = 'column'