sql 替换text字段

最新推荐文章于 2021-01-26 14:32:21 发布

lichengyezi

最新推荐文章于 2021-01-26 14:32:21 发布

阅读量146

点赞数

文章标签： SQL BBS

declare grade_cur Cursor FOR select topicID,convert(varchar(4000),content) as content  from ejf_topic where   content like '%202.97.214.165:8080%'
 declare @detail nvarchar(3000)
 declare @topicID int
OPEN grade_cur
Fetch next from grade_cur into @topicID, @detail
while @@FETCH_STATUS = 0  
begin  

set @detail=REPLACE(@detail,'202.97.214.165:8080/bbs1','bbs.sale3g.com')
print @detail
update ejf_topic   set  content   =@detail  where topicID=@topicID


print @detail

fetch next from grade_cur into @topicID,  @detail
 

end

CLOSE grade_cur
DEALLOCATE grade_cur