Replace text in sql

Sql string function update replace

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

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

Similar codes

0 vote270 views1 answer
Get date ISO in psql
SQL
0 vote259 views1 answer
Date on SQL
SQL
6 votes245 views2 answers
Can't connect to local mysql server through socket
SQL
1 vote267 views3 answers
Connect to mysql c# connection string C#
SQL
36 votes268 views6 answers
Rename table sql
SQL
3 votes266 views4 answers
Psql list tables in schema
SQL
9 votes257 views4 answers
Last mysql
SQL
-1 vote245 views1 answer
Export mysql table to file
SQL
25 votes253 views4 answers
Metadata
SQL
0 vote252 views1 answer
Sql select merge multiple values
SQL