SELECT CONCAT("DROP DATABASE ", SCHEMA_NAME, ";") FROM information_schema.SCHEMATA WHERE SCHEMA_NAME LIKE "test_%";