Replace sql

Replace string value in sql

UPDATE tableName  SET  fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');

UPDATE employees 
SET 
    phone_number = REPLACE(phone_number, '.', '-');

UPDATE employees 
SET 
    phone_number = REPLACE(phone_number, '.', '-');Code language: SQL (Structured Query Language) (sql)

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')

##sql query with replace function
#syntax
UPDATE tableName
SET  column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');

SELECT colonne1, colonne2, REPLACE(colonne3, 'exemple insulte, 'CENSURE')
FROM table

Source: sql.sh

Similar codes