Quick SQL question

any of you know MySQl.
How do I Select all entry that has column TODAY with type DATETIME that occur today? within 3 years?

Any thought?

Query motherfucker, do you use it?

>>1
Perhaps something like...

SELECT * FROM table WHERE TODAY >= (DATE(NOW()) - INTERVAL 3 YEAR) AND DAY(NOW()) = DAY(TODAY) AND MONTH(NOW()) = MONTH(TODAY)

(date in table must be the same or greater as today's date without time minus 3 years, and date in the table must have the same month and day as now.

You may want to save DATE(NOW()), DAY(NOW()) and MONTH(NOW()) into session variables (with SET @var = ...) so you can use @var instead of function calls, which is faster.

SQL> SELECT * FROM girls WHERE want_sex = 1 ORDER BY tits DESC
Empty results (0.00 sec)