Answers for "sql query with replace function"

sql query with replace function

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

Posted by: Guest on January-12-2021

sql replace character in string in all records

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

Posted by: Guest on July-06-2020

Code answers related to "sql query with replace function"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query with replace function"

Code answers related to "sql query with replace function"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query with replace function"

Code answers related to "sql query with replace function"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us