MySQL Replace usage

MySQL Replace usage

Yesterday because of the import of data when a data came out, after the thought of using update and replace combined to do the exercise Oh,
Update tablename Set Fields=replace (' AA ', ' BB ', str) where
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
Insert into table (Id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')
Data is not inserted if the same value exists

2.replace (Object,search,replace)
Replaces all occurrences of search in object with replace
Select replace (' www.163.com ', ' w ', ' Ww ')--->wwwwww.163.com
To replace a AA in the Name field in table tables with BB
Update table Set Name=replace (name, ' AA ', ' BB ')