Re: Select name, email where birthday = ??

[Marcel Forget]

Try:
select name, birthday from atable where month(birthday)=month(now()) and
dayofmonth(birthday)=dayofmonth(now());

Marcel

----- Original Message ----- 
From: "Scott Haneda" <lists@stripped>
To: "MySql" <mysql@stripped>
Sent: Tuesday, May 27, 2003 10:20 PM
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=1