mysql 查找包含特定名字的表

SELECT distinct TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME LIKE '%medias%'