From: Date: May 28 2003 4:31am
Subject: RE: Select name, email where birthday = ??
List-Archive: http://lists.mysql.com/mysql/140957
Message-Id: <000001c324c1$494c2180$6601a8c0@aclaussdesktop>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Where MONTH(birthday)=3DMONTH(now()) AND
DAYOFMONTH(birthday)=3DDAYOFMONTH(now())

Adam Clauss
cabadam@stripped


> -----Original Message-----
> From: Scott Haneda [mailto:lists@stripped]=20
> Sent: Tuesday, May 27, 2003 9:21 PM
> To: MySql
> Subject: Select name, email where birthday =3D ??
>=20
>=20
> Hello, I have a date field in my database
> Format is YYYY-MM-DD
>=20
> Once a day at 12:01AM a script is going to run that will
> Select name, email from users where birthday =3D ??
>=20
> And the ?? Is where I am stuck, I don=B9t care about the year=20
> at all, I just
> need to match on the month and day, how would I do this?
>=20
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> http://www.newgeo.com                       Fax: 313.557.5052
> scott@stripped                            Novato, CA U.S.A.
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   =20
> http://lists.mysql.com/mysql?> unsub=3Dcabadam@stripped
>=20