select TABLE_SCHEMA as '数据库', TABLE_NAME as '表' , COLUMN_NAME as '字段' from information_schema.COLUMNS where COLUMN_NAME like '% company%'; company为你要查询的字段名,注意我写的是模糊查询。