Drop all tables with some prefix

What would be the corresponding SQL for:


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.

run this –

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

copy/paste the output and run that