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');
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)
1STUFF Function: This function is used to
2overwrite existing character or inserts
3a string into another string.
4
5REPLACE function: This function is used
6to replace the existing characters
7of all the occurrences.