You might want to try something like
table birthday
from ""
where (birthday.month=5 and birthday.day=5)
Theoretically even better because you could have a date like 2005-05-01 which would otherwise be caught in a text match of 05-05.
My dates are stored as:
---
birthday: 1997-05-17
---