mysql查询字段在哪个表

----------------查询fans字段在哪个数据库哪个表-----------------------------
 SELECT
TABLE_SCHEMA,
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE

COLUMN_NAME = 'fans'

----------查询fans字段在wljdb数据库的哪个表----------------
SELECT
TABLE_SCHEMA '数据库名',
TABLE_NAME '表名'
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'fans' and TABLE_SCHEMA='wljdb'