SET @tableprefix = 'TABLEPREFIX';
SELECT CONCAT( 'DROP TABLE IF EXISTS ', GROUP_CONCAT(TABLE_NAME) , ' ;' ) INTO @querys FROM information_schema.TABLES WHERE TABLE_NAME LIKE CONCAT(@tableprefix ,'_%'); SELECT @querys;
PREPARE stmt FROM @querys ;
EXECUTE stmt; DROP PREPARE stmt;