Joining two fields into one

June 15, 2010 | In: mysql

I want to get two fields value in a single value and I searched on net many times but today I try to solve at my behalf and I got the solution. Here you will get the solution to get the two fields value as single value:

For example:

Database :  db_bank
Table :  tbl_customer
Fields :  id,  first_name,  last_name

And you want to get first_name and last_name as CustomerName then,

SQL should be:
SELECT CONCAT( cus.first_name, cus.last_name ) AS CustomerName
FROM `db_bank`.`tbl_customer` AS cus
WHERE cus.`id`=[AnyID]
LIMIT 0,  30