试试以下这个,不过update之前先select出来看看是不是你要update的所有记录。
update YOUR_TABLE set COL=concat('/ddupvideo/lala/bmpic/',SUBSTRING_INDEX(v,'/',-1)) where COL like '/upload/lalavideo/%';
update YOUR_TABLE set COL=concat('/ddupvideo/lala/bmpic/',SUBSTRING_INDEX(v,'/',-1)) where COL like '/upload/lalavideo/%';
update YOUR_TABLE set COL=concat('/ddupvideo/lala/bmpic/',SUBSTRING_INDEX(COL,'/',-1)) where COL like '/upload/lalavideo/%';
declare @strOld as varchar(300)
declare @strNew as varchar(300)
set @strOld = '/upload/lalavideo/3104/136884485452007929.jpg'
declare @ind as int
set @ind = CHARINDEX('/',@strOld ,20) +1
--print @ind
set @strNew = '/ddupvideo/lala/bmpic/'+ SUBSTRING(@strOld ,@ind ,len(@strOld)-@ind+1)
print @strNew