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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: How select all records exact x days ago ?

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

to move tables to new version

I use mysql4.1.22. I have some domains which use mysql databases. I am going to change my old machine with a stronger machine. Also I think to install mysql 5.0 Will there be any problem about my domains ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To