To replace a string in MySql in multiple rows, you can use REPLACE method of MySql where you can replace or rename the old values with the new desired values.

Here is a simple method of replacing string in MySql query:

MySql Replace Method

Try out the following query for replacing the values using the MySql Update query with Replace method:

UPDATE table_name
SET field_name = REPLACE (field_name, 'old_text', 'new_text');

Hope this helps you in replacing the values using MySql.