combine field values in SQL

Asked Jul 08 '16 at 17:11

Active Jul 08 '16 at 17:13

Viewed 31 times

I have following data structure in MySQL database:

{
date: text
name: text
}

and a data set:

"2016-01-01" "a1"
"2016-01-02" "a2"
"2016-01-02" "a3"
"2016-01-03" "a4"

I would like to combine "name" field, if the "date" is a same in different rows. So at the end to have something like:

"2016-01-01" "a1"
"2016-01-02" "a2, a3"
"2016-01-03" "a4"

Of course I could iterate over results-array and build a new structure, like this one, programmatically.. but maybe its a faster way to do this directly in SQL Query?

edited Jul 08 '16 at 17:13

asked Jul 08 '16 at 17:11

user1908375

1,069
1
14
33

1

Which `RDBMS` you are using. Generally it is called as `Group Concat` – Pரதீப் Jul 08 '16 at 17:12
SQLITE @ android devices. and MySQL server – user1908375 Jul 08 '16 at 17:15
1

Then why have you mentioned `MySQL` database in first line – Pரதீப் Jul 08 '16 at 17:15
Mainly SQLITE, plus Mysql at centos server – user1908375 Jul 08 '16 at 17:16
Also [related](http://stackoverflow.com/questions/1897352/sqlite-group-concat-ordering) – Giorgos Betsos Jul 08 '16 at 17:17
In `Mysql` you can use `GROUP_CONCAT` in-built function – Pரதீப் Jul 08 '16 at 17:17
Duplicate of SQLite here: http://stackoverflow.com/questions/18778844/group-concat-in-sqlite – Tim Lehner Jul 08 '16 at 17:18

combine field values in SQL

0 Answers0