Example of Replace Mysql Statement:
REPLACE INTO T SELECT * FROM T;
SELECT Replace('SQLTeam.com Rocks!', 'Rocks', 'Rolls')
SELECT Replace('SQLTeam.com Rocks!', 'Yak', 'Tibetan bison')
UPDATE dbo.authors
SET city = replace(city, 'Salt', 'Olympic')
WHERE city LIKE 'Salt%';
Example of Mysql Show Slave Hosts
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
{VALUES | VALUE} ({expr | DEFAULT},...),(...),...
Or:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
Or:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
SELECT ...