mysql查询某个字段在哪些表中

# mysql查询某个字段在哪些表中
SELECT
    * 
FROM
    information_schema.COLUMNS 
WHERE
    TABLE_SCHEMA = '数据库名' 
    AND COLUMN_NAME = '字段名'