CONCAT()¶

Function Description¶

CONCAT() concatenates multiple strings (or only one string) into one string. If all parameters are non-binary strings, the result is a non-binary string. If the argument contains any binary string, the result is a binary string.

If any of the parameters in CONCAT() is NULL, it returns NULL.

Grammar Description¶

>
CONCAT(str1,str2,...)

Parameter definition¶

Parameters	Description
str1,str2,…	Required parameters. Concatenate `str1,str2,..` into a string. Note: If any parameter is `NULL`, return `NULL`.

Example¶

mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| concat(My, S, QL) |
+-------------------------+
| MySQL |
+-------------------------+
1 row in set (0.01 sec)

mysql> SELECT CONCAT('My', NULL, 'QL');
+--------------------------+
| concat(My, null, QL) |
+--------------------------+
| NULL |
+--------------------------+
1 row in set (0.00 sec)

limit¶

CONCAT() currently does not support quotation-marked string parameters and numeric parameters.