select results from specific week

[franco714]

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?

[guelphdad]

im trying something like this but its not working

would you care to enlighten us further?

Is your column actually called TIMESTAMP? OR do you need to substitute the correct column name?

When you state "not working" that doesn't give enough details for people to help you.

[franco714]

by not working, i mean its not returning any results.

the column is actually called date so.
SELECT * FROM table where WEEK(date) = '5'

[r937]

if that query is not returning any rows, that means there aren't any rows which satisfy that partucular WHERE clause