CONCAT() – How to add several strings or Columns together in MySQL?

CONCAT() –

The CONCAT() functions adds several string together.

Syntax –

CONACT(expression1, expression2, expression3)

Example –

SELECT CONCAT("I ", "am ", "Learning ", "SQL.") AS ConcatenatedString;

Another example

SELECT CONCAT(ENAME, " works as " , JOB) AS emp_info
FROM emp;