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

Question

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

User · Answer

When you have three columns   first name  last name  mid name   SELECT CASE      WHEN mid name IS NULL OR TRIM mid name      THEN         CONCAT WS       first name  last name        ELSE          CONCAT WS       first name  mid name  last name        END  FROM USER

User · Answer

rtrim lastname      rtrim firstname  as  Person Name  from Table   the result will show lastname firstname as one column header

User · Answer

You can use a query to get the same   SELECT CONCAT FirstName         MiddleName         Lastname  AS Name FROM TableName    Note  This query return if all columns have some value if anyone is null or empty then it will return null for all  means Name will return  NULL   To avoid above we can use the IsNull keyword to get the same   SELECT Concat Ifnull FirstName            Ifnull MiddleName           Ifnull Lastname       FROM TableName    If anyone containing null value the      space  will add with next value

User · 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

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

Examples related to sql

Examples related to mysql