Problem with mysql query

Question

I am creating a playlist table. I want to print tracklist from database. I have this sequence of data stored in database.

album | track | singer
----------------------
A     |   1   |  X
A     |   1   |  Y
A     |   2   |  X
A     |   3   |  Z

This way that is if track 1 has sung by both x and y combinely than I have stored that in separate record. But at time of print I want to print in differect style...Like

album | track | singer
----------------------
A     |   1   |  X, Y
A     |   2   |  X
A     |   3   |  Z

What query should I fire to print it in desired schema, that is grouping it according to singer.

GolezTrol · Accepted Answer · 2011-09-23 09:59:14Z

6

Use

select album, track, GROUP_CONCAT(singer) from YourTable group by album, track

answered Sep 23, 2011 at 9:59

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

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

Collectives™ on Stack Overflow

Problem with mysql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related