m

meShell

全干工程师

2017/12/13 14:53

在SQL中更新替换字符串

T-SQL:

update TBL 
   set picture = Replace(picture, 'servera', 'serverb') 
 where picture like '%servera%'

Oracle:

update TBL 
   set picture = replace(picture, 'servera', 'serverb') 
 where picture like '%servera%'

MySQL:

update TBL 
   set picture = REPLACE(picture, 'servera', 'serverb') 
 where picture like '%servera%'

Table Of Contents

mysql
sql

meShell 最受欢迎程序解答

最受欢迎程序解答

相关程序解答推荐

上一篇: twig中使用continue和break 下一篇: PHP手撸MQTT客户端

留言