Admin: New page: ==Query== SELECT * FROM `table` WHERE `timestampfield` > subdate(NOW(), INTERVAL 10 MINUTE); OR SELECT * FROM `table` where `timestampfield` > NOW() - INTERVAL 10 M...

2009-06-25T19:56:44Z

New page: ==Query== <source lang="mysql"> SELECT * FROM `table` WHERE `timestampfield` > subdate(NOW(), INTERVAL 10 MINUTE); OR SELECT * FROM `table` where `timestampfield` > NOW() - INTERVAL 10 M...

New page

==Query==
<source lang="mysql">
SELECT * FROM `table` WHERE `timestampfield` > subdate(NOW(), INTERVAL 10 MINUTE);

OR

SELECT * FROM `table` where `timestampfield` > NOW() - INTERVAL 10 MINUTE;
</source>

That would show you all the entries created in the last 10 minutes .. you can replace 'minute' with hour/day/month/year... ofcourse .. you can also replace the number ..

==LINKS==
[http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html MySQL Manual Entry]

[[Category:MySQL]]

MySQL select entries older than - Revision history

Admin: New page: ==Query== SELECT * FROM `table` WHERE `timestampfield` > subdate(NOW(), INTERVAL 10 MINUTE); OR SELECT * FROM `table` where `timestampfield` > NOW() - INTERVAL 10 M...