MySQL get last 24 hours example SQL

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