Join values in different rows into one cloumn

Question

I have a table that has a list of events. I would like to join the unit values from multiple rows into one column for display purposes based on a unique value, "incident".

Current data:

Date Time Incident Unit
1/1  1200  1234    101
1/1  1200  1234    102

How I would like to display it:

Date Time Incident Unit
1/1  1200  1234    101, 102

I am using mysql/php.

Thanks!

And here's a good dupe: stackoverflow.com/questions/276927/… , also stackoverflow.com/questions/12635714/… (this is one case where I am jealous with my otherwise happy SQL Server :-/) — user2246674
– user2246674, Commented Jul 18, 2013 at 22:36

user1646111 · Accepted Answer · 2013-07-18 22:38:37Z

3

Try this query:

SELECT `date`, `time`, `incident`, group_concat(`unit`) 
from table group by `incident`

answered Jul 18, 2013 at 22:38

user1646111

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

Comments

Oguzhan Ozel · Accepted Answer · 2013-07-18 22:37:31Z

0

Use this query

SELECT date, time, incident, GROUP_CONCAT(unit SEPARATOR ", ") AS unit FROM table GROUP_BY incident

answered Jul 18, 2013 at 22:37

Oguzhan Ozel

1,16411 silver badges14 bronze badges

Collectives™ on Stack Overflow

Join values in different rows into one cloumn

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related