View all records in certain year

[devil52]

Hi guys, I hope someone can help!

I have a MySql database, one of the columns saves peoples date of birth in DATE format (0000-00-00)

I need to create a list of all the people who's birthday is in a set month - and then output a list of all their email addresses in a list (stored in another column of the database).

I cannot work out how to do the date exporting!

I know the search must be something like 'find all the records who's date = %%%%-11-%%'

Can anyone please help! I've tried many primitive methods but my query writing skills are not up to scratch!

Many thanks,

Nick

[devinemke]

to get all the birthdays in the current month:

SELECT * FROM table WHERE MONTH(birthday) = MONTH(CURDATE())

you can substitiute CURDATE() with whatever month you want.