MySQL compare now() (only date, not time) with a datetime field
Solution 1:
Use DATE(NOW()) to compare dates
DATE(NOW()) will give you the date part of current date and DATE(duedate) will give you the date part of the due date. then you can easily compare the dates
So you can compare it like
DATE(NOW()) = DATE(duedate)
OR
DATE(duedate) = CURDATE()
See here
Solution 2:
Compare date only instead of date + time (NOW) with:
CURDATE()