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

Reply via email to