Synopsis
CONCAT(str1, str2, ...)
Returns the result of concatenating
str1, str2, and
any other parameters (or NULL if
any argument is NULL). If any of
the arguments are binary, then the result is a binary string;
otherwise, the result is a nonbinary string. This code returns the
string “MySQL”:
SELECT CONCAT('My', 'S', 'QL');