MSSQL Table Search and Replace

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 to

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.

pbody = REPLACE(pbody,'','')
pbody LIKE ''

A search and replace of a MS SQL table replacing a website URL or correcting an error.