MySQL get last 24 hours example SQL

select count(*) as cnt from log where date >= DATE_SUB(CURDATE(),INTERVAL 1 DAY);

Thank you for reading this article MySQL get last 24 hours example SQL With URL http://x-tutorials.blogspot.com/2005/04/mysql-get-last-24-hours-example-sql.html. Also a time to read the other articles.