alex alex - 1 month ago 4
MySQL Question

How do I get first name and last name as whole name in a MYSQL query?

I want to be able to do something like this

SELECT `first_name` + " " + `last_name` as `whole_name` FROM `users`


So basically I get one column back
whole_name
which is
first_name
and
last_name
concatenated together with a
(space).

How do I do that in SQL, or more specifically, MySQL ?

Answer

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws

SELECT CONCAT_WS(" ", `first_name`, `last_name`) AS `whole_name` FROM `users`