if it's only a one-off thing, you could use php to get all table names (mysql_list_tables) and then go thru and create an array of the names that match your criteria, then go thru that array and DROP each one progressivly.
HTH Beau // -----Original Message----- // From: John Hughes [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 16 May 2002 7:41 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] DROP tables with prefix match // // // I need to rebuild a PHP-mySQL site that has an extensive table // structure. Is there a way to DROP all tables that start with a // certain prefix? // // __________________________________________________ // Do You Yahoo!? // LAUNCH - Your Yahoo! Music Experience // http://launch.yahoo.com // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
