for( $i=1;$i<=5;$i++ )
{

 $sql ="SELECT * FROM `表名` WHERE `字段` like '%%' ";
 
 $query = mysql_query( $sql ) or die(mysql_error());
 
 if( mysql_num_rows( $query ) )
 {
  while ( $rs = mysql_fetch_array( $query ) )
  {
   //print_r($rs);
   
   $t = stripslashes($rs['字段']);
   $str = nl2br(strip_tags(addslashes(removelink($t))));
   $sql ="update 表名 set 字段='$str' where id=".$rs['id'];
   
   
   if( mysql_query($sql))
   {
    echo $rs['id'].'成功
';
   }
   else
   {
    echo mysql_error();
   } 
  }
 }
 else
 {
  echo '己更新过没有记录了'.$sql.'
';
 }

}

 
function removelink($t)
{
 //$str = preg_replace("/]*href=[^>]*>|]*>/i","",$t);
 
 $str = preg_replace("/(?is)(?<=

).*?(?=

).*?(?=

).*?(?=

).*?(?=

).*?(?=

 return re_h($str);
}

function re_h($str)
{
 $str = str_replace('

','',$str);
 $str = str_replace('

','',$str);
 $str = str_replace('

','',$str);
 $str = str_replace('

','',$str);
 $str = str_replace('

','',$str);
 $str = str_replace('

preg_replace("/(?is)(?<=

).*?(?=

ereg_replace(']*)>([^<]*)','2',$content);

ereg_replace("]*>|","",$content); 

$find="this string is my find";
$string='替换掉了';//将超链接替换成的内容
echo ereg_replace(']*)>([^<]*'.$find.'[^>]*)','2',$content);