Page 1 of 1

MySQL records

Posted: Wed Mar 16, 2005 10:20 pm
by thesimon
Hello,

My news table(mysql) has a year field as such

Year
--------
2000
2000
2001
2001
2003
2005
2005
2005

I was wondering if you could select from this table so you only get one of each year, so the output would be

2000
2001
2003
2005

Is this possible, I was trying to think of an algorithm that would work, but I have had no luck yet?



Thanks,

Simon

Posted: Wed Mar 16, 2005 10:24 pm
by feyd
hint: DISTINCT or GROUP BY

Legend

Posted: Wed Mar 16, 2005 10:33 pm
by thesimon
Where would we be without smart people, thanks so much for your help, it works :)