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

```SQL 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.