xxxxxxxxxx
UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');
xxxxxxxxxx
UPDATE employees
SET
phone_number = REPLACE(phone_number, '.', '-');
xxxxxxxxxx
##sql query with replace function
#syntax
UPDATE tableName
SET column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');
#Example
Update tbl_employee
Set designation = REPLACE(designation, 'SEO', 'Developer');
xxxxxxxxxx
##sql query with replace function
#syntax
UPDATE tableName
SET column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');
xxxxxxxxxx
UPDATE employees
SET
phone_number = REPLACE(phone_number, '.', '-');Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
SELECT colonne1, colonne2, REPLACE(colonne3, 'exemple insulte, 'CENSURE')
FROM table
xxxxxxxxxx
SELECT REPLACE(thestring_with-unwanted_chars, unwanted_chars, '')
xxxxxxxxxx
# change gender from male to female, and from female to male
UPDATE salary SET sex =
CASE sex
WHEN 'm' THEN 'f'
ELSE 'm'
END;
# or
update Salary set sex = if(sex='m', 'f', 'm');