Update a column value, replacing part of a string

• How to Replace Part of a String in MySQL
• Replace part of string in mysql table column
• Find and Replace text in the entire table
• MySQL REPLACE String Function: Find & Replace Text

Replace the bold text as per your table name, field/column name, strings and conditions.

UPDATE table_name
SET field_name = REPLACE(field_name, 'string_to_find', 'string_to_replace')
WHERE conditions;

Example,
Table name: publication_settings
Field/column name: setting_value
String to change: Copyright © to ©

where conditions
Field/column name: setting_name
Field string/value: abstract

UPDATE publication_settings
SET setting_value = REPLACE(setting_value, 'Copyright ©', '©')
WHERE setting_name LIKE ('abstract');