Update a column value, replacing part of a string

here is how we can replace partial of the string on all rows in MySQL: 

UPDATE my_table_name
SET my_field_name = REPLACE(my_field_name, 'unwanted-string', 'new-string');