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
MySQL records
Moderator: General Moderators