CONCAT

Declaration

CONCAT(str1, str2, ...)

Description

Concatenates multiple strings into one string. If all parameters are non-binary strings, the result is a non-binary string. If any parameter is a binary string, the result is a binary string. Numeric parameters are converted to their equivalent non-binary string form.

If any parameter is NULL, the result is NULL.

Examples

SELECT
   CONCAT('test','obclient', '1.0'),
   CONCAT('test','obclient', NULL)
   \G
*************************** 1. row ***************************
CONCAT('test','obclient', '1.0'): testobclient1.0
 CONCAT('test','obclient', NULL): NULL
1 row in set (0.001 sec)