Home / Funtions and Operators / Question No: 103

I want to concat the values of two columns of the table. The column names are first_name and last_name in my table. Is there any MySQL function which returns both the names in one column like below:

buyer_name
-------------
Kenneth Marcus
Ashley Lewis
James Bond

MySQL provides CONCAT function to do so. Take an example query:

SELECT CONCAT(first_name, ' ', last_name) FROM buyer;