Rows with a DateTime in the past

$sql1 = "SELECT * FROM my_table WHERE my_date_field < NOW()";

Time based condition

//Where timestamp is more recent than (Now() - # mins)
$sql1 = "SELECT * FROM tblStatus WHERE MyDateTimeColumn > DATE_SUB(now(), INTERVAL 5 MINUTE)";

//Where timestamp is older than (Now() - # mins)
$sql1 = "SELECT * FROM tblStatus WHERE MyDateTimeColumn < DATE_SUB(now(), INTERVAL 5 MINUTE)";

//Where DateTime is more recent than (Now() + # mins)
$sql1 = "SELECT * FROM tblStatus WHERE MyDateTimeColumn < DATE_ADD(now(), INTERVAL 5 MINUTE)";

Argument can be:

• MICROSECOND
• SECOND
• MINUTE
• HOUR
• DAY
• WEEK
• MONTH
• QUARTER
• YEAR