List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 19 2002 3:17pm
Subject:Re: Birthday select
View as plain text  
>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

Thread
Birthday selectSoheil Shaghaghi19 Apr
  • Re: Birthday selectPaul DuBois19 Apr
  • RE: Birthday selectGurhan Ozen19 Apr
    • RE: Birthday selectKeith C. Ivey19 Apr
      • RE: Birthday selectGurhan Ozen19 Apr