Retrieving all the years in datetime field

[MikeSpider]

Hi guys,
My project stores user data in a db and i want to display this data dinamicaly to the user according
to his activity in particular years.

I need to select all the years recorded in db.

I tried "SELECT YEAR(date_column) FROM table_name" ;

not working .

PS: the dates are recorded on a datetime field type.

thanks in advance.

[MikeSpider]

ok i sorted it out.

"SELECT YEAR(date) AS year FROM tbl_name";
the problem now is that it gives me exactly all the years entered in db repeatedly.
it gives-me:
2009
2009
2009
2011
2012
2012

I just need one of each, which should be:
2009
2011
2012

I'm sorry if this seems like a beginner's question :S.
any help will be appreciated.

Mike

[johnj]

try select distinct.

[MikeSpider]

It works! Thanks a lot Johnj.
I was trying with the array_unique, but was only returning one date and not one of each.
Is good to learn something new everyday.

Cheers
Mike