php+mysql next 5 bithdays

From: Floortje (floortje-apestaartjexs4allpuntnl_at_hetminnetjehoort.erbij)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 14:46:33 +0200

Hey people,

I have a mysql date (YYYY-MM-DD) field with birthdates of dogs. Is it
possible to select the 5 next birthdays. Ive tried stuff like SELECT
(RIGHT(CUR_DATE(),5)-RIGHT(birthday,5)) etc. with no succes. Any clues
anyone ?

Floortje