MySql gets the sql statement for which table a field exists

 
SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1'

col1 is the subsegment name.