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.