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?