mysql查询包含某个字段的表有哪些

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME = '字段名' 
-- AND TABLE_SCHEMA='数据库名' 
-- AND TABLE_NAME NOT LIKE '表明%';