[ddtpmyra]

Hi,
I have one table and I wanted to segregate the columns by each type. Below is example of the table and result that I wanted. Please tell me how to excute this on a mysql query.

TABLE_FRUITS
name - color
apple - green
mango - yellow
banana- yellow
guava - green

RESULT I WANT
GREEN YELLOW
guava banana
apple mango

[Atli]

Hi.

MySQL is meant to store data, not re-arrange it in pretty formations.
That would be the job of the API you use to display your results, like say PHP for a web page.

It probably can be done with a SQL query, but it is usually far easier and more efficient to do that using the front-end API.