The use of Replace in MySQL

MySQL Replace usage

1.replace into
Replace into table (Id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')
The purpose of this statement is to insert two records into table tables. If the primary key ID is 1 or 2 does not exist
is equivalent to
Insert into table (Id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')
Data is not inserted if the same value exists

2.replace (Object,search,replace)

Replace all occurrences of search in object with replace

Select replace (' Www.jb51.net ', ' w ', ' Ww ')--->wwwwww.jb51.net

Example: Replacing AA in the Name field in table tables with BB

Update table Set Name=replace (name, ' AA ', ' BB ')