Delete all tables with same prefix

[a1amattyj]

hi,

 

ive read up on Delete all tables with same prefix and apparently you cant use a wildcard function when trying to do this with php.

 

Although, do you know of a way to do this? (Delete all tables in mysql which use the prefix set in a variable).

 

thanks.

[PFMaBiSmAd]

Use a query like the following to get a list of matching table names, then loop through the results and delete each one -

 

SHOW TABLES FROM db_name LIKE 'pattern'

[Orio]

<?php

mysql_connect("localhost", "user", "pass");
mysql_select_db("dbname");

$prefix = "tbl";
$result = mysql_query("SHOW TABLES LIKE '{$prefix}%'");
while($table = mysql_fetch_array($result))
mysql_query("DROP TABLE `{$table[0]}`");

?>

 

Orio.