Hi,

Drop Multiple Tables;

SELECT CONCAT("DROP TABLE ", GROUP_CONCAT(table_name), ";") FROM
information_schema.tables

WHERE table_schema = "drupal6" AND table_name LIKE "mysite_%";...