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 have a date field in my database > Format is YYYY-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 this? > > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
