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