# **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**

```text
>
CONCAT(str1,str2,...)
```

## **Parameter definition**

| Parameters | Description |
| ---- | ---- |
| str1,str2,... | Required parameters. Concatenate `str1,str2,..` into a string. <br>Note: If any parameter is `NULL`, return `NULL`. |

## **Example**

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