Hello, I have a date field in my database
Format is -MM-DD
Once a day at 12:01AM a script is going to run that will
Select name, email from users where birthday = ??
And the ?? Is where I am stuck, I don¹t care about the year at all, I just
need to match on the month and day, how would I do
Hello, I have a date field in my database
Format is -MM-DD
Once a day at 12:01AM a script is going to run that will
Select name, email from users where birthday = ??
And the ?? Is where I am stuck, I don¹t care about the year at all, I just
need to match on the month and day, how would I do
Where MONTH(birthday)=MONTH(now()) AND
DAYOFMONTH(birthday)=DAYOFMONTH(now())
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 9:21 PM
To: MySql
Subject: Select name, email where birthday = ??
Hello, I
Try:
select name, birthday from atable where month(birthday)=month(now()) and
dayofmonth(birthday)=dayofmonth(now());
Marcel
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:20 PM
Subject: Select name, email where