mysql multiple row to single row

Question

post_id organisation_id
            1   5
            2   57
            3   57
            4   57
            5   58
            6   59
            7   60
            8   61
            8   62
            9   59
            11  57
            12  57
            4   62

is there anyway to select post_id, organisation_id1, organisation_id2 in a single row?

Can you show what your expected results would look like?

Joe Stefanelli
– Joe Stefanelli

2011-01-10 19:43:09 +00:00
Commented Jan 10, 2011 at 19:43 — Joe Stefanelli
– Joe Stefanelli, Commented Jan 10, 2011 at 19:43

Wolph · Accepted Answer · 2011-01-10 19:45:02Z

3

Since you didn't specify what your table looks like and what would be the outcome that you would like, this is just a guess.

SELECT
    a.post_id,
    a.organisation_id,
    b.organisation_id
FROM your_table a
LEFT JOIN your_table b
    ON a.post_id = b.post_id AND a.organisation_id < b.organisation_id

answered Jan 10, 2011 at 19:45

Wolph

80.4k12 gold badges142 silver badges152 bronze badges

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

Comments

Joe Stefanelli · Accepted Answer · 2011-01-10 19:42:36Z

1

Is this what you're looking for?

select post_id, group_concat(organisation_id)
    from YourTable
    group by post_id;

answered Jan 10, 2011 at 19:42

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

1 Comment

Damian Sia Over a year ago

it returns post_id group_concat(organisation_id) 1 [BLOB - 1B] 2 [BLOB - 2B] 3 [BLOB - 2B] 4 [BLOB - 5B] 5 [BLOB - 2B] 6 [BLOB - 2B] 7 [BLOB - 2B] 8 [BLOB - 5B] 9 [BLOB - 2B] 11 [BLOB - 2B] 12 [BLOB - 2B]

Collectives™ on Stack Overflow

mysql multiple row to single row

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related