SELECT * from `your_table_name` WHERE DAY(time) = DAY(NOW())

##</code><code>##

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