SQL Function Reference

CONCAT
Returns a string created by concatenating all arguments
MySQL
CONCAT(str, [str,] ...)
If at least one of the arguments is NULL, returns NULL.
Examples
MySQL
SELECT CONCAT('sql', '-', 'academy');
MySQL
SELECT CONCAT('sql', NULL);