/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

9 votes188 views2 answers
Nosql databases
SQL
0 vote247 views1 answer
Download mysql database to excel in android studio
SQL
14 votes199 views5 answers
Set password for postgres user ubuntu
SQL
42 votes274 views6 answers
Install beautifulsoup
SQL
0 vote195 views1 answer
Group_concat only returns one row
SQL
2 votes222 views1 answer
Import large .sql files into lampp
SQL
25 votes210 views4 answers
Sqlserver add column
SQL
2 votes158 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote228 views1 answer
Postgresql blocked on mac
SQL
0 vote203 views1 answer
Get employees if not contains in sql
SQL

Share