Mysql Concat() function

Usage 1

SELECT CONCAT("This  ", "is  ", "test ", "concatenation") AS testConcatenation;

Syntax

concat(exp1, exp2, exp3, ..) - exp1 is required

Usage 2

Concat table field and text together

SELECT CONCAT(NAME, " is creted at  ", created_at, " ") AS Address
FROM province;

Enjoy...