Page 1 of 1

select birthday query

Posted: Mon Oct 27, 2008 6:18 am
by itsmani1
Hi

I am making a birthday database. I have saved date of birth as '12-12-1985' Now i want to select all the birthday that are in December, Need help in query if possible.

Regards,
dizyn

Re: select birthday query

Posted: Mon Oct 27, 2008 6:39 am
by onion2k
Look at MySQL's "MONTH()" and "YEAR()" functions.