RE: Select name, email where birthday = ??

[Adam Clauss]

Where MONTH(birthday)=MONTH(now()) AND
DAYOFMONTH(birthday)=DAYOFMONTH(now())

Adam Clauss
cabadam@stripped


> -----Original Message-----
> From: Scott Haneda [mailto:lists@stripped] 
> 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: [phone]
> http://www.newgeo.com                       Fax: [phone]
> scott@stripped                            Novato, CA U.S.A.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=cabadam@stripped
>