mysql 查询字段所在表

SELECT
	TABLE_SCHEMA as '数据库名称',
	TABLE_NAME as '表名',
	COLUMN_NAME as '字段名称'
FROM
	information_schema.COLUMNS 
WHERE
	column_name = '字段名称'