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 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/[EMAIL PROTECTED]