How to drop all JEMH Tables on mysql

The Mysql workbench doesn't make this easy, but the following query will generate a drop statement:

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) 
    AS statement FROM information_schema.tables 
    WHERE table_schema = 'YOUR_JIRA_SCHEMA' table_name LIKE 'AO_78C957_%';

The result of running this is a query that can then be run to drop all the tables.