CONCAT()

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)

Constraints

Currently, CONCAT() doesn't support quoted strings and numeric argument.