Re: Birthday select

[Paul DuBois]

>Hi everyone.
>I have a sql database of users with their birth date (Y/M/D).
>
>Can anyone please tell me how I can check whose birthday each day is, and
>pull them from the database?

WHERE MONTH(birth) = MONTH(CURDATE())
AND DAYOFMONTH(birth) = DAYOFMONTH(CURDATE())

I'm assuming you have birth date stored in a single field "birth".
>
>Thanks,
>Soheil