Drop all tables that start with some prefix

drop_tables

SELECT 
  CONCAT(
    "DROP TABLE ",  
    GROUP_CONCAT(
      CONCAT(TABLE_NAME, "\n")
    )
  ) AS stmt 
FROM information_schema.TABLES 
WHERE TABLE_SCHEMA = "DatabaseName" AND TABLE_NAME LIKE "prefix_%"