How to concatenate multiple strings together using the CONCAT() function?

CONCAT(string1, string2, ...) is a MySQL built-in function that concatenates multiple strings together. For example:

SET @host = 'dba';
SET @domain = 'FYIcenter.com';

SELECT CONCAT(@host, '.', @domain);
  -- +-----------------------------+
  -- | CONCAT(@host, '.', @domain) |
  -- +-----------------------------+
  -- | dba.FYIcenter.com           |
  -- +-----------------------------+

Reference information of the CONCAT() function:

CONCAT(str1, str2, ...): str
  Returns the string that results from concatenating the arguments. May
  have one or more arguments. If all arguments are nonbinary strings, the
  result is a nonbinary string. If the arguments include any binary
  strings, the result is a binary string. A numeric argument is converted
  to its equivalent nonbinary string form.

Arguments, return value and availability:
  str1: Required. The first given string to concatenate for.
  str2: Optional. The second given string to concatenate for.
  str: Return value. The string of concatenation of all given strings.
  Available since MySQL 4.0.

Related MySQL functions:

• CONCAT_WS() - Concatenation with Separator

⇒ CONCAT_WS() - Concatenation with Separator

⇐ COLLATION() - Detecting Character Collation Name

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References