Is there an SQL command (for MySQL) that means I can drop specific tables. i.e. all those starting "nuke_"?
AFAIK there is no simple way of doing this, and IMHO they should really change the syntax to:
DROP TABLE <tablename> LIKE 'table%'