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

Answer 1

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

This should work always

Answer 2

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

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