Select Code to Download

-- today
SELECT * from `your_table_name` WHERE 
...
--won't work at the beginning of the year
SELECT * from `your_table_name` WHERE 
  YEARWEEK(time, 0) = YEARWEEK(NOW(), 0)