MySQL Function Reference

CONCAT

Returns a string created by concatenating all arguments

MySQL 8.1

CONCAT(str, [str,] ...)

If at least one of the arguments is NULL, returns NULL.

Examples

MySQL 8.1

SELECT CONCAT('sql', '-', 'academy');

MySQL 8.1

SELECT CONCAT('sql', NULL);