27,579
社区成员
发帖
与我相关
我的任务
分享
update products
set pro_img=SUBSTRING_INDEX(SUBSTRING_INDEX(pro_mimg,'|',2),'|',-1),
pro_mimg=right(pro_mimg,length(pro_mimg)-length(SUBSTRING_INDEX(pro_mimg,'|',1))-1)
update products set pro_img=
substring(pro_mimg,instr(pro_mimg,'|')+1,locate(pro_mimg,'|',instr(pro_mimg,'|'))-instr(pro_mimg,'|')-1),
pro_mimg=right(pro_mimg,length(pro_mimg)-instr(pro_mimg,'|'))
where pro_img='4108mbXO7-L.jpg'
create table products(pro_img nvarchar(100),pro_mimg nvarchar(200))
insert into products select '4108mbXO7-L.jpg','4108mbXO7-L.jpg|41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.jpg|none|none|none|none'
go
update products set pro_img=
substring(pro_mimg,charindex('|',pro_mimg),charindex('|',pro_mimg,charindex('|',pro_mimg)-charindex('|',pro_mimg)-1)),
pro_mimg=right(pro_mimg,len(pro_mimg)-charindex('|',pro_mimg))
where pro_img='4108mbXO7-L.jpg'
go
select * from products
go
drop table products
/*
pro_img pro_mimg
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|41oSD8U1dVL.jpg 41oSD8U1dVL.jpg|31KNYvN7d5L.jpg|41vHjpK5pZL.jpg|none|none|none|none
(1 行受影响)
*/
update tb set pro_mimg=replace(pro_mimg,pro_img+'|','')
update products set pro_mage=
substring(pro_mimg,charindex('|',pro_mimg),charindex('|',pro_mimg,charindex('|',pro_mimg)-charindex('|',pro_mimg)-1)),
pro_mimg=right(pro_mimg,len(pro_mimg)-charindex('|',pro_mimg))
where pro_img='4108mhX07-L.jpg'