Advanced Search

Select Records older than one week

/ Published in: MySQL
Save to your folder(s)
Display records older than one week.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT *
  2. FROM
  3. tablename
  4. WHERE
  5. tablename.tabledatefield < DATE_SUB( NOW(), INTERVAL 7 DAY )

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.