Posted By

galofre on 06/24/10


mysql select records older

Versions (?)

Who likes this?

2 people have marked this snippet as a favorite


Select Records older than one week

 / Published in: MySQL

Display records older than one week.

  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.