Return to Snippet

Revision: 27827
at June 24, 2010 20:28 by galofre


Initial Code
SELECT *
FROM
tablename
WHERE
tablename.tabledatefield < DATE_SUB( NOW(), INTERVAL 7 DAY )

Initial URL


Initial Description
Display records older than one week.

Initial Title
Select Records older than one week

Initial Tags
mysql

Initial Language
MySQL