RE: Selecting the most recent entry for each object.

2008-03-20 Thread Edward Corbett
PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Selecting the most recent entry for each object. Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote: > Hi, > > > > I have a load of reviews in a table and, for each person I want to pull out > the

Re: Selecting the most recent entry for each object.

2008-03-20 Thread Baron Schwartz
Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote: > Hi, > > > > I have a load of reviews in a table and, for each person I want to pull out > the most recent review. > > > > So, if I wanted to do this for a single person I would order by date desc > and use "limit

Selecting the most recent entry for each object.

2008-03-20 Thread Edward Corbett
Hi, I have a load of reviews in a table and, for each person I want to pull out the most recent review. So, if I wanted to do this for a single person I would order by date desc and use "limit 1". But I'm not sure how to do this in bulk. Thanks.