I want to compare the current date of my server with a date stored in a mySQL database

Question

How can I compare the current date of the web server with a date I have stored in the mySQL database and 3 days before that that in the database to send a notification email ?

Answer 1

This will select rows whose mydate is at least 3 days earlier than the current date:

SELECT  *
FROM    mytable
WHERE   mydate <= SYSDATE() - INTERVAL 3 DAY

Answer 2

You just need to write a program which queries the db and get all email ids which has (now()-3) = field in db you are comparing against and send mail to those email ids and add it as a scheduled task/crontab which will get executed daily(schedule time when web server is less utilized).