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
SELECT ... FROm table WHERE datecolumn=NOW();
Gurhan
-Original Message-
From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Birthday select
Hi everyone.
I have a sql database of users with their birth date (Y/M/D).
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 11:47 AM
To: [EMAIL PROTECTED]
Subject: RE: Birthday select
On 19 Apr 2002, at 11:21, Gurhan Ozen wrote:
SELECT ... FROm table WHERE datecolumn=NOW();
Do you have a lot of newborn users at your