> Basically just do a a php script the sends the sql "show tables"; > > Then do a strchr() to see if "a" is the first letter in the resuts and if > so do a delete table. > > Just yo play safe do a dump of your db first.
Or even better, use SHOW TABLES LIKE 'a%' to just get the a* tables and drop each one. How do you know whether it's an "active" a* table or not? Will you be dropping a table that someone is actually using? ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
