MySQL Concat .. As

Question

I am trying to put an alias for the result of a concat command in MySQL, I have seen it done in different questions such as this one however it doesn't seem to be working with me.

Here's my query:

SELECT CONCAT(`firstname`,' ',`lastname`) FROM `cms_users` AS username

The result is coming up like this:

[0] => Array
     (
        [CONCAT(`firstname`,' ',`lastname`)] => fname lname
     )

[1] => Array
    (
        [CONCAT(`firstname`,' ',`lastname`)] => fname lname
    )

[2] => Array
    (
        [CONCAT(`firstname`,' ',`lastname`)] => fname lname
    )

The end result I am after is this:

[0] => Array
     (
        [username] => fname lname
     )

[1] => Array
    (
        [username] => fname lname
    )

[2] => Array
    (
        [username] => fname lname
    )

Try SELECT CONCAT(`firstname`,' ',`lastname`) AS username FROM `cms_users` — Vivek Pratap Singh, Feb 06 '15 at 05:44

score 0 · Answer 1 · answered Feb 06 '15 at 05:44

0

Give alias name for column not for the table.

SELECT CONCAT(`firstname`,' ',`lastname`) username FROM `cms_users`

answered Feb 06 '15 at 05:44

Saravana Kumar

3,569
4
13
31

score 0 · Answer 2 · answered Feb 06 '15 at 05:45

0

Try SELECT CONCAT(firstname,' ',lastname) AS username FROM cms_users

answered Feb 06 '15 at 05:45

Vivek Pratap Singh

8,296
5
17
34

score 0 · Accepted Answer · answered Feb 06 '15 at 05:45

SELECT CONCAT(`firstname`,' ',`lastname`) FROM `cms_users` AS username

change this to

SELECT CONCAT(`firstname`,' ',`lastname`) AS username FROM `cms_users`

in your query your actually giving alias to table name which is wrong the alias should be given to column name.

MySQL Concat .. As

3 Answers3