mysql模糊查找数据库使用的字段名

select
table_schema,
table_name,
column_name
from information_schema.`COLUMNS`
where table_schema='库名' and column_name like '%字段%'