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');
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.