如果是一个字段且一条记录,则:
update tblname set pic=replace(pic,'jpghttp','jpg$http')如果是一个字段且以上一行一条记录,则:
declare @tmpstr varchar(8000)
set @tmpstr=''
select @tmpstr=@tmpstr+pic from tblname
select @tmpstr
update tblname set pic=replace(pic,'jpghttp','jpg$http')如果是一个字段且以上一行一条记录,则:
declare @tmpstr varchar(8000)
set @tmpstr=''
select @tmpstr=@tmpstr+pic from tblname
select @tmpstr
如果是一个字段且以上一行一条记录,则:
declare @tmpstr varchar(8000)
set @tmpstr=''
select @tmpstr=@tmpstr+pic+'$' from tblname
select @tmpstr
在添加时每添加完一条就换一行
然后提交进数据库的
如当前id为1的记录中pic字段就是以上的值,怎么update?
update tabname
set fieldname=replace(fieldname,'jpg'+char(10)+'http','jpg'+'$'+'http')
http://image1.10123.net/g/功夫旋风儿/Vol_59/5901.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5902.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5903.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5904.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5905.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5906.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5907.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5908.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5909.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5910.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5911.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5912.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5913.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5914.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5915.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5916.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5917.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5918.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5919.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5920.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5921.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5922.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5923.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5924.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5925.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5926.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5927.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5928.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5929.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5930.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5931.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5932.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5933.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5934.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5935.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5936.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5937.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5938.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5939.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5940.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5941.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5942.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5943.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5944.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5945.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5946.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5947.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5948.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5949.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5950.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5951.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5952.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5953.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5954.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5955.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5956.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5957.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5958.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5959.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5960.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5961.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5962.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5963.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5964.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5965.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5966.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5967.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5968.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5969.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5970.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5971.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5972.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5973.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5974.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5975.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5976.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5977.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5978.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5979.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5980.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5981.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5982.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5983.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5984.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5985.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5986.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5987.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5988.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5989.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5990.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5991.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5992.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5993.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5994.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5995.JPG
http://image1.10123.net/g/功夫旋风儿/Vol_59/5996.JPG
update table set pic = pic + '$' + @tmp
--这个要特殊处理下啊.