Re: How select all records exact x days ago ?

[Shawn Green (MySQL)]

On 7/31/2011 13:18, yavuz maslak wrote:
>
> I don't want all records during 5 days ( 24*5days ) . Only I need  records
> at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
>
> How can I do that ?
>

Show us your table definition (the "CREATE TABLE ..." form, please), 
tell us which column you want to base your time comparison on, and 
someone will show you an example.

-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN