Mysql 根据字段查询所有表

#根据字段差表

SELECT DISTINCT TABLE_NAME FROM information_schema.`COLUMNS` WHERE

COLUMN_NAME = 'cert_status' AND TABLE_SCHEMA = 'gteam_manage' AND TABLE_NAME NOT LIKE 'vm%';