Posted by David Robley on 03/17/05 06:32

Simon Allison wrote:

> Hello,
>
>
>
> My news table has a year field as such
>
>
>
> Year
>
> --------
>
> 2000
>
> 2000
>
> 2001
>
> 2001
>
> 2003
>
> 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?

Use mysql DISTINCT

SELECT DISTINCT(year-field) FROM table

[Back to original message]