$today = strtotime('09-12-2012');

"SELECT * FROM `table` WHERE `birthdate` >= $today AND `birthdate` <= $today + 86400 ORDER BY `id` asc"