mysql 查询字段名所在的表

select * from (select * from information_schema.COLUMNS where table_schema = '数据库名') temp where column_name = '字段名'