数据库整张表替换指定字符串

PHP接口方法

		$s = Db::name('jvideo')->order('id desc')->select();
        foreach ($s as $k=>$v){
            $url = $v['v_url'];
            $newurl = str_replace("video.test.com","video.test.net",$url);
            Db::name('jvideo')->where('id',$v['id'])->update(array('v_url'=>$newurl));
        }

MYSQL

    UPDATE jvideo SET v_url = (REPLACE(v_url,'video.test.com','video.test.net'));