How to replace a substring in a given string using the REPLACE() function?

REPLACE(str, from_str, to_str) is a MySQL built-in function that repeats a substring in a given string. For example:

SET @str = 'dba.FYIcenter.com';

SELECT REPLACE(@str, 'dba', 'dev');
  -- +-----------------------------+
  -- | REPLACE(@str, 'dba', 'dev') |
  -- +-----------------------------+
  -- | dev.FYIcenter.com           |
  -- +-----------------------------+

Reference information of the REPLACE() function:

REPLACE(str, from_str, to_str): modstr
  Returns the string str with all occurrences of the string from_str
  replaced by the string to_str. REPLACE() performs a case-sensitive match
  when searching for from_str.

Arguments, return value and availability:
  str: Required. The given string to be modified.
  from_str: Required. The substring to be replaced.
  to_str: Required. The string to be replaced with.
  modstr: Return value. The modified string.
  Available since MySQL 4.0.

⇒ REVERSE() - Reversing String

⇐ REPEAT() - Repeating String

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References