Temporal Selection

To select by a recent rolling temporal window, say -- "in the last 30 minutes," try something like:

SELECT COUNT(*) FROM mytable WHERE lastupdate > DATE_SUB(NOW(), INTERVAL 30 MINUTE);