CONCAT()¶

This function CONCAT() returns the string that results from concatenating the arguments.

Description¶

This function CONCAT() 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.

CONCAT() returns NULL if any argument is NULL.

Syntax¶

>
CONCAT(str1,str2,...)

Arguments¶

Arguments	Description
str1,str2,…	Required. The str to add together. Note: If any of the strs is a NULL value, it returns NULL.

Examples¶

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)