I would like to find out if someone can help me to optimize the date range calculation in the following query:

Code:
SELECT
	USERID,
	birthday
FROM members
WHERE
	birthday BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 100 YEAR) AND DATE_SUB(CURRENT_DATE(), INTERVAL 0 YEAR)
	OR birthday='0000-00-00'
;
I want a speedy birthday comparison over huge users database.
Thank you.