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 ?
>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)".
> 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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.