How to replace string from a table column in MySQL?

Update Part of String in Table Column

In a table column which have string value, you might need to update any part of string. Like I had to change the part of URL in string. I table column I had http://anyurlold.com/link which I changed to http://anyurlnew.com/link. For this I used MySQL REPLACE function as following.

UPDATE links
SET link = REPLACE(link, 'http://anyurlold.com/', 'http://anyurlnew.com/')

You can also add “WHERE” clause as per your requirement.