replace(c1,c2[,c3])
在字符串c1中找到字符串c2,替换成c3.
若c3为空,则在c1中删除所有c2.
例:update articledoi set local_url=replace(
(select local_url from articledoi where id=311) , ' :8888/pub ' , ':80 ' )
where id=297;(单行替换)
在字符串c1中找到字符串c2,替换成c3.
若c3为空,则在c1中删除所有c2.
例:update articledoi set local_url=replace(
(select local_url from articledoi where id=311) , ' :8888/pub ' , ':80 ' )
where id=297;(单行替换)