$sql = 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="new"';

$tables =$this->model->query($sql);

$alter_sql = '';

foreach ($tables as $t){

$new_name = preg_replace('#^old#','new',$t['TABLE_NAME']);

strcmp($new_name,$t['TABLE_NAME']) && $alter_sql .='ALTER TABLE'.$t['TABLE_NAME'].'RENAME TO '.$new_name.';<br>';

}