mysql的interval_MySQL INTERVAL分钟

I am trying to get the all records which are 2 hours or more old using this query:

$minutes = 60 * 2

SELECT COUNT(id) AS TOTAL, job_id

from tlb_stats

WHERE log_time >= DATE_SUB(CURRENT_DATE, INTERVAL $minutes MINUTE)

GROUP BY job_id

It only selects the recent records and skips the old. When I change log_time <= ... it only selects old and skips which are the new one.

What am I doing wrong?

解决方案

Try:

$minutes = 60 * 2

SELECT COUNT(`id`) AS `TOTAL`, `job_id`

FROM `tlb_stats`

WHERE `log_time` < DATE_SUB(NOW(), INTERVAL $minutes MINUTE)

GROUP BY `job_id`

use backticks to quote fields (words like "total" and "id" may someday mean something in MySQL)

use NOW() for CURRENT_DATE just means 2010-08-04, not including the time

use < to get entries older than that date.