Birthdays this we

[Anon]

I am trying to select birthday s for TODAY from my DOB field... via my select statement

WHERE

MONTH(dob) and DAY(dob) =

NOW(MONTH) and NOW(day)

Can anyone help me syntax this out???

[linus]

It should be something more like:

WHERE

MONTH(dob) = NOW(MONTH) AND
DAY(dob) = NOW(DAY)

I'm not sure about this NOW(DAY) business though, I've never worked with that before.

[Anon]

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Richie.
geocities.com/akindele/