Example
Add several strings together:
SELECT CONCAT("SQL ", "Tutorial ", "is ", "fun!") AS ConcatenatedString;
Definition and Usage
The CONCAT() function adds two or more expressions together.
Note: Also look at the CONCAT_WS() function. Continue reading MySQL CONCAT() Function