MySQL records
Posted: Wed Mar 16, 2005 10:20 pm
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
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