concat values group by mysql

Question

how to get from this:

id   foo_name
1        A
2        A
3        A
4        A
5        B
6        B
7        B
8        A
9        B
10       A

to this: 1 row only

foo_names
A,B

I tried using GROUP_CONCAT but it give me this:

A,A,A,A,A,A,A,

B,B,B,B

score 0 · Answer 1 · answered May 12 '20 at 20:47

0

You can use:

select group_concat(distinct foo_name) as foo_names
from t;

answered May 12 '20 at 20:47

Gordon Linoff

Sorry, i wasn't clear enough but I have edited the question and it should only return in one row – woninana May 12 '20 at 20:50
@woninana . . . Did you run this? It returns one row with just two values in the name. That's what you asked for. – Gordon Linoff May 12 '20 at 21:11

score 0 · Answer 2 · answered May 12 '20 at 20:48

0

With group_concat():

select group_concat(distinct foo_name order by foo_name) foo_names
from tablename

See the demo.

answered May 12 '20 at 20:48

forpas

2 Answers2