Concatenating columns with mysql

Question

I am struggling with a small problem. I have a table as follows

name id
a    1
b    1
c    2
d    2
e    3
f    4

I need output as follows.

a-b  1
c-d  2
e    3
f    4

I need to get the concatenated name for a given ID.I tried using concat function but i ended up empty handed.

souslov · Accepted Answer · 2015-01-07 08:36:33Z

8

SELECT id
     , GROUP_CONCAT(name SEPARATOR '-') AS name 
FROM table 
GROUP BY id

souslov

44.7k11 gold badges92 silver badges113 bronze badges

answered Sep 30, 2013 at 11:21

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

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

3 Comments

@AngeloNeuschitzer Yeah,GROUP_CONCAT is one of Mysql`s gems.

Does it support for sql as well?

@user2037445 No,you have to do some acrobatics for that. social.msdn.microsoft.com/Forums/sqlserver/en-US/…

souslov · Accepted Answer · 2015-01-07 08:37:26Z

3

SELECT group_concat(`name` SEPARATOR '-') AS NAMES
     , `id` 
FROM Table1
GROUP BY `id`;

souslov

44.7k11 gold badges92 silver badges113 bronze badges

answered Sep 30, 2013 at 11:23

Praveen Prasannan

7,15310 gold badges53 silver badges71 bronze badges