MONTH(TODAY) Commands

[Craig Tidwell]

I have a line in mySQL that I need to select anyone whose birthday is today.

The field name is BIRTHDATE and is shown in the database as mm/dd/yyyy. How do I select the current month and day so that I can use someone's birthday from 8/22/1970 or 8/22/1975 or 8/22/1950...etc.

I was instructed to use this, but it's not working...
mySQL="SELECT * from EE_info where MONTH(TODAY)=MONTH(BIRTHDATE) and DAY(TODAY)=DAY(BIRTHDATE)";

Any help would be greatly appreciated.

Thanks,

-Craig from Michigan.