week(NOW()) starts on Sunday Need to start on Monday

Question

right now I have this pulling data for the current week, but the week starts on sunday, I would like the day to start on Monday how can I do this?

$result = mysql_query("SELECT * FROM form_2 WHERE week(timestamp) = week(NOW())");

Answer 1

According to the docs, use WEEK(timestamp,1)

Answer 2

You could try: "SELECT * FROM form_2 WHERE week(timestamp - INTERVAL 1 DAY) = week(NOW() - INTERVAL 1 DAY)"