简单好用,废话少说,看代码. 

<?php
mysql_connect('host','username','password');
mysql_select_db('');
$rs=mysql_query('show tables');

while($arr=mysql_fetch_array($rs)){
    $TF=strpos($arr[0],'class_');
    if($TF===0){
        $FT=mysql_query("drop table $arr[0]");
        if($FT){
            echo "$arr[0] 删除成功！<br>";
            }
        }
    }
?>