advanced code snippet search

Posted By

galofre on 06/24/10


Tagged

mysql select records older


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

dantreacy
kidmizere


Select Records older than one week

 / Published in: MySQL
 

Display records older than one week.

Expand | Embed | Plain Text 
  1. SELECT *
  2. FROM
  3. tablename
  4. WHERE
  5. tablename.tabledatefield < DATE_SUB( NOW(), INTERVAL 7 DAY )

Report this snippet  

You need to login to post a comment.