MySQL: Get multiple row's different values to one single column

Question

This is my table structure

My table name siteInfo

id    | key         | value

1     | facebook    | facebook.com

2     | twitter     | twitter.com

3     | googleplus  | google.com

4     | linkedin    | linkedin.com

here how i can get facebook and googleplus values from single sql column

You've posted the same question here: stackoverflow.com/questions/23149606/… And I answered in a way that would work. Why have you asked the question again? — Helpful
– Helpful, Commented Apr 18, 2014 at 8:00

Ravi Dhoriya ツ · Accepted Answer · 2014-04-18 08:12:03Z

0

I think this is what you are looking for,

select group_concat(`value` separator ', ') url
from siteinfo
where `key` in ('facebook','googleplus');

here is, SQLFiddle

answered Apr 18, 2014 at 8:12

Ravi Dhoriya ツ

4,4148 gold badges39 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

MySQL: Get multiple row's different values to one single column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related