From: Date: May 28 2003 4:20am
Subject: Select name, email where birthday = ??
List-Archive: http://lists.mysql.com/mysql/140956
Message-Id: <BAF96B13.3068D%lists@newgeo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

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.