From: shawn wilson Date: July 31 2011 5:59pm Subject: Re: How select all records exact x days ago ? List-Archive: http://lists.mysql.com/mysql/225448 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable mysql> select day(now())-5; +--------------+ | day(now())-5 | +--------------+ | 26 | +--------------+ 2011/7/31 yavuz maslak : > > I don't want all records during 5 days ( 24*5days ) . Only I need =A0reco= rds > 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 =3D > 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmaslak@ihlas.= net.tr > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dag4ve.us@gmai= l.com > >