Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

Name

CONCAT()

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');