1##sql query with replace function
2#syntax
3UPDATE tableName
4SET column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');
5
6#Example
7Update tbl_employee
8Set designation = REPLACE(designation, 'SEO', 'Developer');
1UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');
1##sql query with replace function
2#syntax
3UPDATE tableName
4SET column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');
1REPLACE function: This function is used
2to replace the existing characters
3of all the occurrences.
1UPDATE employees
2SET
3 phone_number = REPLACE(phone_number, '.', '-');Code language: SQL (Structured Query Language) (sql)