so i have a bunch of timestamps saved in my database, and im trying to return the results from a certain week. Say week 5 of this year (first week of feb).
im trying something like this but its not working
SELECT * FROM table where WEEK(timestamp) = '5'
am i missing something?