Updating Part of a Column Value For Many Records

Let’s say you have a table where you store paths of somes files uploaded through your web application.

Those path start with \\original-network-drive, which is a network path in Windows-style, at the beginning of the project. But then, the network path changes. How do you write an update statement to make sure all records point to the new network path?

The SQL

1
2
3

UPDATE Files
SET Path = REPLACE(Path, '\\original-network-drive', '\\new-network-drive')
WHERE Path LIKE '\\original-network-drive%';

That’s it!