Get all MySQL rows that are one week old

SELECT DATE_SUB(date_time_column, INTERVAL 1 WEEK) FROM your_table;

Download this snippet

Twitter Twitter

3 Comments to “ Get all MySQL rows that are one week old”

  1. Anonymous  on Sep 04, 2009

    OXSR3B <a href="http://irmgqwyxnlwy.com/">irmgqwyxnlwy</a>, [url=http://oduejepqfmgx.com/]oduejepqfmgx[/url], [link=http://fophascfflcm.com/]fophascfflcm[/link], http://efuhdymdxkhw.com/

  2. Anonymous  on Sep 25, 2009

    eOjaDR <a href="http://xcujzeensfdc.com/">xcujzeensfdc</a>, [url=http://uahjyjcwalch.com/]uahjyjcwalch[/url], [link=http://qqkwxgjouvca.com/]qqkwxgjouvca[/link], http://ircbynbrxtcz.com/

  3. Anonymous  on Mar 14, 2010

    GOCWck <a href="http://fdebfvrrcaum.com/">fdebfvrrcaum</a>, [url=http://hueqqryaksgt.com/]hueqqryaksgt[/url], [link=http://oosrterdcsuq.com/]oosrterdcsuq[/link], http://balfldgqjtbc.com/

Leave a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>