php distinct year

[jonbyo6t9]

hi.. i am just wondering how to select DISTINCT all the YEARS in a dateTime field. the data in the table looks like this.


ID, datetime, eventName
1, 2008-12-01 01:10:20, test 1
2, 2007-12-01 01:10:20, test 2
3, 2008-12-01 01:10:20, test 3
4, 2006-12-01 01:10:20, test 4
5, 2008-12-01 01:10:20, test 5
6, 2007-12-01 01:10:20, test 6


i would like to return the following:

ID, datetime, eventName
1, 2008-12-01 01:10:20, test 1
4, 2006-12-01 01:10:20, test 4
6, 2007-12-01 01:10:20, test 6

does that make any sense at all??

many thanks in advance

[Jake Arkinstall]

Try this:

SELECT ID, YEAR(datetime) YEAR, datetime, eventName FROM YourTable GROUP BY YEAR(datetime)

Year should hold the year in question, if you want it.

[jonbyo6t9]

wow thanks for the quick response... it worked perfectly!