How to trim a string using the TRIM() functions?

TRIM(LEADING|TRAILING|BOTH remstr FROM str) is a MySQL built-in function that trims a string. For example:

SELECT TRIM('   dba.FYIcenter.com  ');
  -- +--------------------------------+
  -- | TRIM('   dba.FYIcenter.com  ') |
  -- +--------------------------------+
  -- | dba.FYIcenter.com              |
  -- +--------------------------------+

Reference information of the TRIM() function:

TRIM(LEADING|TRAILING|BOTH remstr FROM str): modstr
  Returns the string str with all remstr prefixes or suffixes removed. If
  none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is
  assumed. remstr is optional and, if not specified, spaces are removed.

Arguments, return value and availability:
  str: Required. The string that will be extracted from.
  LEADING|TRAILING|BOTH remstr FROM: Optional.
    Default is BOTH ' ' FROM. Specifies trimming behavior.
  remstr: Optional. The substring to be trimmed off.
  modstr: Return value. The modified string
  Available since MySQL 4.0.

Related MySQL functions:

• LTRIM() - Left-Trimming String
• RTRIM() - Right-Trimming String

⇒ UCASE() - Synonym for UPPER()

⇐ TO_BASE64() - Base64 Encoding

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References