Seleting records
This is a discussion on Seleting records within the PHP General forums, part of the PHP Programming Forums category; Hello, My news table has a year field as such Year -------- 2000 2000 2001 2001 2003 2005 2005 I was ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2005
|
|||
|
|||
Seleting records
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? Thanks, Simon 
|
|
03-17-2005
|
|||
|
|||
|
Re: Seleting records
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
|
Linear Mode
