批量删除mysql数据库共同前缀的表

SELECT
    CONCAT(
        "DROP TABLE ",
        GROUP_CONCAT(TABLE_NAME)
    ) AS stmt
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME LIKE "classified_%";