如何替换 SQL Server 表列中的字符串

我有一个表(SQL Sever),它引用了路径(UNC 或其他),但现在路径要改变了.

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change.

在路径列中,我有很多记录,我只需要更改路径的一部分,而不是整个路径.我需要在每条记录中将相同的字符串更改为新的字符串.

In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And I need to change the same string to the new one, in every record.

如何使用简单的 update 来做到这一点?

How can I do this with a simple update?

推荐答案

就是这么简单:

update my_table
set path = replace(path, 'oldstring', 'newstring')

相关文章