SQL – Update a column value, replacing part of a string

Update a column value, replacing part of a string

 

In short:

UPDATE table_name
SET field_name = REPLACE(field_name, 'string part to replace', 'replacing_string')

 

Advertisements