Here a fast snippet

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

If useful, you can also set a where condition.

Advertisements