printing sql query result in a single line [duplicate]

Question

I have two columns (groupID, memberID) in table and I execute following mysql query

select `groupID` from `tbl_groupassign` where `memberID` = 'check1';

which prints column groupID but I want to show groupID in single row with each groupID separated by comma. For example I get following result by executing above query

groupID

group1

group2

but I want show it as group1, group2

Maxim Krizhanovsky · Accepted Answer · 2013-09-23 08:41:15Z

7

Use GROUP_CONCAT

SELECT GROUP_CONCAT(`groupID` SEPARATOR ',') FROM `tbl_groupassign` WHERE `memberID` = 'check1' GROUP BY `memberID`;

answered Sep 23, 2013 at 8:41

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

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

1 Comment

prattom Over a year ago

very fast reply. Thanks for the solution.

Collectives™ on Stack Overflow

printing sql query result in a single line [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related