mysql 替换字段里的某段字符串
2019-08-16 本文已影响0人
a79c8fd95bf3
sql：
update raw_inquiriesset
extend =REPLACE(extend,
substring(extend,locate('enquiry_id":',extend),locate('"commission',extend)-locate('enquiry_id":',extend)-1 ) ,
concat('enquiry_id":',(1158602+round(rand()*1000,0))))
where id in (
)
