Drop all tables with some prefix

[bimalpoudel]

What would be the corresponding SQL for:

DROP TABLES LIKE 'test_%';

I just want to delete all the tables that have 'test_' as a prefix.
The current one does not work. It is a sample only to let you know what I wanted.

[r937]

run this --

SELECT CONCAT('DROP TABLE ',table_name,';')
  FROM information_schema.tables
 WHERE table_name LIKE 'm%'

copy/paste the output and run that