DROP table from prefix

drop.sql

/**
* Delete table in MySQL from theri prefix.
*/

DECLARE @prefix VARCHAR(255) = 'mytableprefix'
SET GROUP_CONCAT_MAX_LEN=10000;
SET @tbls = (SELECT GROUP_CONCAT(TABLE_NAME)
	FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = 'my_database'
    AND TABLE_NAME LIKE @prefix + '_%');
SET @delStmt = CONCAT('DROP TABLE ',  @tbls);
-- SELECT @delStmt;
PREPARE stmt FROM @delStmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;