List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:July 31 2011 10:24am
Subject:Re: How select all records exact x days ago ?
View as plain text  
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
Thread
How select all records exact x days ago ?yavuz maslak31 Jul
  • Re: How select all records exact x days ago ?Johan De Meersman31 Jul
    • RE: How select all records exact x days ago ?yavuz maslak31 Jul
      • Re: How select all records exact x days ago ?shawn wilson31 Jul
      • Re: How select all records exact x days ago ?MySQL)1 Aug
      • Re: How select all records exact x days ago ?Johan De Meersman1 Aug