hello

I have this table, with two columns, one contains email adresses and the other contains the date

email date

1@g.com date1
3@g.com date1
2@g.com date2

I need a mysql query that outputs this:

date1

1@g.com
3@g.com

date2

2@g.com

thanks in advanced.

no, that's a cosmetic re-arrangement of data which should be provided by a very straightforward and simple query

do that in your application language, not in sql

thank you, Ill follow your advise and tell you later.