Cacher is the code snippet organizer for pro developers

SELECT 
    table_name, 
    column_name, 
    data_type,
    ordinal_position

FROM  INFORMATION_SCHEMA.COLUMNS 

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