sql replace Ìæ»»×Ö¶ÎÖв¿·ÝÖ¸¶¨ÄÚÈÝ

sql replace Ìæ»»×Ö¶ÎÖв¿·ÝÖ¸¶¨ÄÚÈÝ
´´½¨Êý¾Ý¿â½Ì³Ì
create database cnnet;
´´½¨Êý¾Ý±í
CREATE TABLE `cnnet`.`test` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT ,
`url` VARCHAR( 50 ) NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
²å¼¸ÌõÊý¾Ý:
INSERT INTO `test` (`id`, `url`) VALUES
(1, 'www.1aa.cm'),
(2, 'www.1aa.cm'),
(3, 'www.1aa.cm'),
(4, 'www.1aa.cm'),
(5, 'www.111cn.net'),
(6, 'www.111cn.net');
ÏÂÃæÎÒÃÇÀ´¿´¿´sql replace Ìæ»»×Ö¶ÎÖв¿·ÝÖ¸¶¨ÄÚÈÝÈëÃŽ̳̰ɡ£
´´½¨Êý¾Ý¿âÁ¬½Ó
*/
$cn = mysql½Ì³Ì_connect('127.0.0.1','root','root') or die('Êý¾Ý¿âÁ¬½Óʧ°Ü');
$sql = "select * from test where  url like '%1aa.cm%' ";
$result = mysql_db_query( 'cnnet',$sql,$cn );
while( $rs = mysql_fetch_array( $result ) )
{
 echo $rs['url'],'<br />';
}
/*
Êä³ö½á¹û
www.1aa.cm
www.1aa.cm
www.1aa.cm
www.1aa.cm
ºÃ½á¹û³öÀ´ÁË£¬ÎÒÃÇÕýʽ½øÐÐÕýÌ⣬replaceÌæ»»ÄÚÈÝ£¬ÎÒÃÇÒªÇó°Ñ1aa.cmÈ«²¿Ìæ»»³É111cn.net
*/
$sqlReplace ="update test set url = replace('1aa.cm','111cn.net',url) WHERE url like '%1aa.cm%'";
mysql_db_query('cnnet',$sqlReplace,$cn);
if( 1 )
{
 $sql = "select * from test ";
 $query = mysql_db_query('cnnet',$sql,$cn );
 while( $row = mysql_fetch_array( $query ) )
 {
  echo $rs['url'],'<br />';
 } 
}
else
{
 echo '¼ì²éÄãµÄsqlÓï¾ä£¬Ð»Ð»';
}
/*
Êä³ö½á¹û£º
www.111cn.net
www.111cn.net
111cn.net
111cn.net
111cn.net
111cn.net
×¢Ã÷±¾Õ¾Ô­´´ÎÄÕÂתÔØ×¢Ã÷À´Ô´www.111cn.net