Re: Seleting records
| From: | David Robley | Date: | Thu, 17 Mar 2005 04:32:23 +0000 |
| Subject: | Re: Seleting records | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-210933@lists.php.net to get a copy of this message | ||
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