CONCAT

Syntax

CONCAT(str1, str2, ...)

Purpose

Concatenates multiple strings into one string. If all parameters are nonbinary strings, the result is a nonbinary string. If any parameter is a binary string, the result is a binary string. For numeric parameters, they are converted to their equivalent nonbinary string representations.

If any parameter is NULL, the result is NULL.

Examples

obclient> SELECT
     CONCAT('test','obclient', '1.0'),
     CONCAT('test','obclient', NULL)
     \G
*************************** 1. row ***************************
CONCAT('test','obclient', '1.0'): testobclient1.0
 CONCAT('test','obclient', NULL): NULL
1 row in set