How to Concat 2 Column values in MySQL?

Answer:

With the help of CONCAT in-built mysql function,we can add 2 column values to make one value as shown:-

select Concat(employee_firstname,' ',employee_lastname) as 'Employee Full Name' from employee_master where status = 'AA';

We can Concat more columns as many as we can,

select Concat(Concat(employee_firstname,' ',employee_lastname),' ',employee_code) as 'Employee Name' from employee_master where status = 'AA';