Mysql get values from all rows but in one record by comma separated

Question

Below is my table

-----------------------------------
|id|     |Zone|    |State         |
--------------------------
|1|     |Zone1|    | State1,State2|

|2|     |Zone2|    | State3,State4|

|3|     |Zone3|    | State5|

I try with group concatenate it shows 3 different records, I want in one record all concatenated by comma like

State1, State2, State3, State4, State5

I try with this query

select group_concat(state separator ',') as state from zone group by title

Your query has "group by title" but there is no title column in your table. Can you show your full table or better still make an SQL Fiddle. — PaulF, Jun 15 '16 at 11:32
GROUP BY to concatenate strings in MySQL : http://stackoverflow.com/q/149772/3835843 — Arif, Jun 15 '16 at 11:54

score 4 · Accepted Answer · answered Jun 15 '16 at 11:30

4

Please tell me what is "title" field in your table. You can try select group_concat(state separator ',') as state from zone. Do not use group by title.

answered Jun 15 '16 at 11:30

kaushik karan

351
2
7

score 3 · Answer 2 · answered Jun 15 '16 at 11:36

3

Group By title

SELECT group_concat(state) as State 
FROM zone GROUP BY title;

To get all data in comma separated data in single row

SELECT group_concat(state) as State 
FROM zone;

Refer : http://sqlfiddle.com/#!9/9d5aa/1

answered Jun 15 '16 at 11:36

zakhefron

1,403
1
9
13

Mysql get values from all rows but in one record by comma separated

2 Answers2

Linked