I'll grant the MySQL is arguably less capable than some older established servers, but it's respectably simple for the task at hand:

select count(*) from mytable where TO_DAYS(datecol) > TO_DAYS(NOW()) -
+ 1
[download]