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 ...