Cacher is the code snippet organizer for pro developers

-- MySQL compare now() (only date, not time) with a datetime field

SELECT * FROM table1 WHERE DATE(dtime) >= CURDATE();

-- http://stackoverflow.com/questions/14533914/mysql-compare-now-only-date-not-time-with-a-datetime-field
-- TRY SELECT * FROM table1 WHERE dtime >= CURDATE();