From: Johan De Meersman
Date: July 31 2011 10:24am
Subject: Re: How select all records exact x days ago ?
List-Archive: http://lists.mysql.com/mysql/225445
Message-Id: <205b0aed-3bcf-4b78-a1b0-4c9880830dee@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Depends on how your table is set up (you're going to need a date in the data...) but probably something along the lines of "where createDate = date_sub(now(), interval 5 days)".

----- Original Message -----
> From: "yavuz maslak" <maslak@stripped>
> To: mysql@stripped
> Sent: Sunday, 31 July, 2011 11:46:14 AM
> Subject: How select all records exact x days ago ?
> 
> Hi
> 
> How can I get all records exact 5 days ago from a table, neither 6
> days nor
> 4 days ?
> 
> Could you give me an example ?
> 
> Thanks
> 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel