I have an sql select statement that returns all rows who's "last_edited" variable (timestamp) is within the current week:
SELECT vote FROM votes WHERE WEEK(vote_time)=WEEK(now())
This works very well, but I want the week to start on Monday and not Sunday, so I tried this:
SELECT vote FROM votes WHERE WEEK(vote_time, 1)=WEEK(now(), 1)
but this is not returning any results. Any idea why?