Contributor
Kyle
April 15
Edit

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');

Send us a message. We will reply as soon as we can.
×