mysql - Return all items in one row [duplicate]

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-24 01:49:33Z

4

Use group_concat():

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

edited Nov 24, 2017 at 1:49

answered Nov 24, 2017 at 1:47

Harshil Doshi

3,6123 gold badges18 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harshil Doshi · Accepted Answer · 2017-11-24 01:56:22Z

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, 2017 at 1:56

Harshil Doshi

3,6123 gold badges18 silver badges41 bronze badges

answered Nov 24, 2017 at 1:55

Pramod Kharade

2,0951 gold badge26 silver badges41 bronze badges

2 Comments

Pramod Kharade Over a year ago

Thanks @Harshil for formatting ans. I had given ans from mobile phone so I was not able to format.

Harshil Doshi Over a year ago

No worries. BTW the link mentioned in your answer is not redirecting to documentation.

Collectives™ on Stack Overflow

mysql - Return all items in one row [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related