UPDATE employees SET phone_number = REPLACE(phone_number, '.', '-');
Update tbl.Products Set articlenumber = replace(articlenumber, 's401', 'I00010')
UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');