Script for remove in one command all tables in databases, by given template

mysql_remove_tables_by_database_or_tables_prefix.sql

SET GROUP_CONCAT_MAX_LEN=10000;

SET @del = (
  SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(CONCAT('`' , TABLE_SCHEMA , '`.`',table_name,'`')) , ';' )
    AS statement FROM information_schema.tables
  WHERE
  TABLE_SCHEMA LIKE 'MY_DB_PREFIX_%'   /* Criteria for selection   */
  OR TABLES.TABLE_NAME LIKE 'MY_TABLE_PREFIX_%';
);

PREPARE stmt FROM @del;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;