SQL更新中的str_replace吗?

更新时间：2023-02-05 21:19:32

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%'

上一篇 : ：链表多个父和子节点下一篇 : 使用 str_replace 转义短代码

相关阅读

技术问答最新文章