I want to put 'given' and 'surname' column together into 'fullname' in SQL, how would i go about in doing so. tnx

Question

I currently have them separated but would prefer to have both together in one column.

If you want to do this in a select statement, use one of the answers below. To permanently change your table, see this answer: http://stackoverflow.com/questions/5774532/mysql-combine-two-columns-and-add-into-a-new-column — user681574, Mar 16 '17 at 04:27

tatskie · Accepted Answer · 2017-03-16T04:50:17.080

0

SELECT CONCAT(given, ' ', surname) AS fullname FROM tablename

or for null safe,

SELECT CONCAT_WS(' ', given, surname)  AS fullname FROM tablename

edited Mar 16 '17 at 04:50

answered Mar 16 '17 at 04:22

tatskie

score 0 · Answer 2 · answered Mar 16 '17 at 04:24

0

you can concatenate them using:

select CONCAT(given,' ',surname) as fullname;

answered Mar 16 '17 at 04:24

Rush

2 Answers2