Birthdays

[bxgirl]

Using mySQL 4.0, I'm trying to retrieve birthdays between the beginning of the year to the present. This is what I've got. Is there a more elegant way of getting this info?

SELECT
c.lname
c.fname
c.datebirth
FROM cutomer c
WHERE (MONTH(c.datebirth) between MONTH('2006-01-01') and MONTH('2006-05-03') AND DAYOFMONTH(c.datebirth) between DAYOFMONTH('2006-01-01') and DAYOFMONTH('2006-05-03')) ORDER BY c.datebirth DESC

 

[r937]

WHERE MONTH(c.datebirth) 
    < MONTH(current_date)
   or (
      MONTH(c.datebirth) 
    = MONTH(current_date)
  AND DAYOFMONTH(c.datebirth) 
   <= DAYOFMONTH(current_date)
      )

r937.com | rudy.ca

 

[bxgirl]

Thanks!