SELECT * from `your_table_name` WHERE 
  YEAR(time) = YEAR(NOW()),
  DAYOFYEAR(time) = DAYOFYEAR(NOW())