Consider a database table of posts or pages.
The website address has changed, perhaps from the development URL to the live website
Or maybe the website’s URL is to change from example.co.uk to example.com.
The tables are to be updated, ideally searching and replacing the old value with a new one.
Given below is a search and replace for the table post, replacing the URL entries in the field pbody.
UPDATE post SET pbody = REPLACE(pbody,'example.co.uk','example.com') WHERE pbody LIKE '%example.co.uk%'
A search and replace of a MS SQL table replacing a website URL or correcting an error.