Delete all tables in a database that match a specific prefix

deleteTables.sql

/*
 * Drop all tables with specific prefix
 * Based on: http://stackoverflow.com/a/24668848
 * Modified for my needs
 *
 */
SET @database_name = 'database';
SET @table_prefix = 'prefix%';
SET FOREIGN_KEY_CHECKS = 0;
SET GROUP_CONCAT_MAX_LEN = 100000;

SELECT * FROM (
    SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(TABLE_NAME) , ';')
    FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_SCHEMA = @database_name AND TABLE_NAME LIKE @table_prefix
) a INTO @tbls;

PREPARE stmt FROM @tbls;
EXECUTE stmt;

SET FOREIGN_KEY_CHECKS = 1;