From: Date: May 28 2003 4:40am
Subject: Re: Select name, email where birthday = ??
List-Archive: http://lists.mysql.com/mysql/140960
Message-Id: <007101c324c2$93af7230$6400a8c0@cr461986b>
MIME-Version: 1.0
Content-Type: multipart/alternative;	boundary="----=_NextPart_000_006E_01C324A1.0BA34590"

------=_NextPart_000_006E_01C324A1.0BA34590
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

Marcel

----- Original Message -----=20
From: "Scott Haneda" <lists@stripped>
To: "MySql" <mysql@stripped>
Sent: Tuesday, May 27, 2003 10:20 PM
Subject: Select name, email where birthday =3D ??


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 =3D ??

And the ?? Is where I am stuck, I don=B9t 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
scott@stripped                            Novato, CA U.S.A.


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Dlmforget2@stripped

------=_NextPart_000_006E_01C324A1.0BA34590--