SQL replace

Very handy SQL statement to replace part of a string that exists in multiple entries within a field of a table:

UPDATE table_name set field_name=replace(field_name, 'old_string', 'new_string')
where field_name LIKE '%old_string%'