Update table field by replacing a string value with a new one

Let’s suppose you have a mysql database and you need to update only a part of a field’s value, not all.

UPDATE `table` SET `field` = REPLACE(`field`, "old_string", "new_string");