declare @a int set @a=0 while @a<=100 begin update table set title=(Select Replace(title,'<mce:script src="http://cn.daxia123.cn/cn.js" mce_src="http://cn.daxia123.cn/cn.js"></mce:script>','') from table where id=@a) where id=@a set @a=@a+1 end