replace characthe sql code example
Example: replace string value in sql
UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');
UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');