select * from table where InsertDate = date_sub(now,interval 1 day) limit 3;
Not tested, but i think it will work fine. ""Vittorio Zuccalà"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hello, > i've a table with a lot of field and in particular: > "InsertDate","Box","Prt" > Example: > InsertDate, Box, PRT > 2006-11-01, BXT, 34 > 2006-11-01, TTS, 33 > 2006-11-01, RRT, 55 > 2006-11-02, BXT, 22 > 2006-11-02, TTS, 99 > 2006-11-02, SAR, 75 > > > I'd like to find all record inserted in the last day... > In this example the last three records... > I do not know which is the last day before > > Any suggestions? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
