selecting records from last week

[wil831]

in mysql, if i define a week as starting from monday and ending on sunday,

how would i do count all records submitted last week?

this is what i'm trying to do, but i don't know the code for it:

"SELECT count(*) FROM table WHERE datetime_column=<records submitted last week>"

[cahva]

Try this:
"SELECT count(*) FROM table WHERE WEEK(datetime_column,1)=WEEK(NOW(),1)-1"