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