sql query for days until next birthday?

[eluser]sophistry[/eluser]
i like the PHP solution because it is more readable. thanks, nick.

@shiggins - could you elaborate? i've been down multiple paths to get to this, so if you have some code to share that would be great!

here's how you can use DATEDIFF to get "age in days", but it quickly becomes more complicated when you want "days until next birthday"

Code:

$this->db->select("short_name, DATEDIFF(CURDATE(), birthday) AS age_in_days");