select count(*) from mytable where TO_DAYS(datecol) > TO_DAYS(NOW()) - 1