How to group data from database by particular column?

Question

I have the following dataset:

ToDo_Name      List_ID
-------------------------------
Read book          1
Study English      2
Do excercises      2
Sleep              1
Eat                1

I need to group this data by List_ID creating the array like this (and send it as json to frontend):

$result = array(
      array("listId" => 1, array('Read book', 'Sleep', 'Eat ')),
      array("listId" => 2, array('Study English', 'Do excercises'))
);

I can't understand - should I do this using some SQL query or PHP array methods? Will be happy to hear any advices...

`select listId, group_concat(ToDo_Name) from yourtable group by listId` — splash58, Sep 09 '18 at 16:50
continuing on @splash58's answer, use `explode` function in php on the `group_concat`'s result string, to convert into array. — Madhur Bhaiya, Sep 09 '18 at 16:51

score 0 · Answer 1 · answered Sep 09 '18 at 16:50

0

You could use group concat ..

  select list_id, group_concat(ToDo_Name)
  from mytable 
  group by  list_id

answered Sep 09 '18 at 16:50

ScaisEdge

131,976
10
91
107

How to group data from database by particular column?

1 Answers1