sql columns adding

Question

I am trying to add two columns as one column by using this statement

SELECT (member_Firstname+''+member_Lastname) AS Name FROM members

but it gives all 0 values in mysql workbench

sql-server is not the right tag if this is for mysql. sql-server is the tag for Microsoft SQL Server. — Nick Meldrum
– Nick Meldrum, Commented Jun 14, 2011 at 12:08

AjayR · Accepted Answer · 2011-06-14 12:16:07Z

7

SELECT concat(member_Firstname,'',member_Lastname) AS Name FROM members;

This should work always

edited Jun 14, 2011 at 12:16

answered Jun 14, 2011 at 12:08

AjayR

4,1894 gold badges49 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user682417 Over a year ago

SELECT DISTINCT concat(member_Firstname,'',member_Lastname) As Name FROM members WHERE Name Like 'a%' but i got the error like this Unknown column 'Name' in 'where clause' would you pls help

AjayR Over a year ago

you cannot use alias names for conditions use complete function like ... where concat(member_Firstname,'',member_Lastname) like 'a%'

UltraCommit · Accepted Answer · 2011-06-14 12:10:38Z

2

I think that in MySQL you should use CONCAT, as follows:

mysql> SELECT CONCAT('My', 'S', 'QL'); -> 'MySQL'

answered Jun 14, 2011 at 12:10

UltraCommit

2,2927 gold badges43 silver badges61 bronze badges

Comments

Spudley · Accepted Answer · 2011-06-14 12:12:16Z

1

Adding is for numbers; for joining strings, use concat()

SELECT CONCAT(string1,string2,string3,etc) FROM table

answered Jun 14, 2011 at 12:12

Spudley

169k39 gold badges240 silver badges309 bronze badges

Comments

Talha Ahmed Khan · Accepted Answer · 2011-06-14 12:12:01Z

0

SELECT CONCAT(CAST(int_col AS CHAR), char_col);

CONCAT() returns NULL if any argument is NULL.

So for the example

SELECT CONCAT(member_Firstname, member_Lastname);

answered Jun 14, 2011 at 12:12

Talha Ahmed Khan

15.6k10 gold badges46 silver badges49 bronze badges

2 Comments

user682417 Over a year ago

SELECT DISTINCT concat(member_Firstname,'',member_Lastname) As Name FROM members WHERE Name Like 'a%' i got error when i am executing the this statement saying that " Unknown column 'Name' in 'where clause' "

UltraCommit Over a year ago

You have to write: WHERE concat(member_Firstname,'',member_Lastname) LIKE 'a%' INSTEAD OF WHERE NAME LIKE 'a%'

Collectives™ on Stack Overflow

sql columns adding

4 Answers 4

2 Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related