mysql - Return all items in one row

Question

Is there a function in mysql that would return all items in just one row?

EXAMPLE:

Table:

| id | name |
-------------
| 1  | john |
| 2  | mike |
| 3  | jane |

Query:

SELECT concat_name(name) FROM tbl_name

concat_name as the function.

Expected Result:

|       name      |
-------------------
| john, mike, jane|

Harshil Doshi · Accepted Answer · 2017-11-24T01:49:33.767

4

Use group_concat():

select group_concat(name order by id separator ',') as name
from table;

edited Nov 24 '17 at 01:49

answered Nov 24 '17 at 01:47

Harshil Doshi

3,497
3
14
37

score 0 · Answer 2 · edited Nov 24 '17 at 01:56

0

Use GROUP_CONCAT FUNCTION

http://dev.mysql.com/tech-resources/articles/4.1/grab-bag.html

SELEct m.meal_Id, 
        GROUP_CONCAT(dish_id) dish_ids, 
        GROUP_CONCAT(dish_name) dish_names
 FROM DISH_HAS_DISHES m JOIN DISH d ON (m.dish_id = d.dish_id)
 GROUP BY meal_Id

edited Nov 24 '17 at 01:56

Harshil Doshi

3,497
3
14
37

answered Nov 24 '17 at 01:55

Pramod Kharade

2,005
1
22
41

Thanks @Harshil for formatting ans. I had given ans from mobile phone so I was not able to format. – Pramod Kharade Nov 24 '17 at 02:02
No worries. BTW the link mentioned in your answer is not redirecting to documentation. – Harshil Doshi Nov 24 '17 at 02:05

mysql - Return all items in one row

2 Answers2