/SQL/Replace text in sql

Replace text in sql

Sql string function update replace

UPDATE employees 
SET 
    phone_number = REPLACE(phone_number, '.', '-');Code language: SQL (Structured Query Language) (sql)

1

Source: sqltutorial.org

Replace text in sql

##sql query with replace function
#syntax
UPDATE tableName
SET  column_name = REPLACE(column_name, 'fromStringValue', 'toStringValue');

0

Similar codes

1 vote127 views1 answer
Sql server today minus n
SQL
1 vote149 views1 answer
Oracle see column type
SQL
0 vote131 views1 answer
TSQL convert csv to table
SQL
0 vote118 views1 answer
Function sum(text) does not exist postgres
SQL
11 votes117 views3 answers
Change column name sql server management studio
SQL
0 vote117 views1 answer
Tsql cmd exec script from file
SQL
0 vote152 views2 answers
Sql unique
SQL
3 votes125 views1 answer
Unsigned int in mysql
SQL
0 vote118 views1 answer
What is delimiter in mysql
SQL
0 vote168 views1 answer
Oracle temporary table
SQL

Share