select data from database

Question

Hi...

 i am having the table.. that stores the date of birth in "yyyy-mm-dd" format.  i want to select the candidates who all are having birthday today based on the today day and month. i don't know how to select the data's by day and month in date column. can u help me solve this.