[SOLVED] MYSQL select statement for 'this week' or 'since sunday'

[fxr]

is anyone capable of writing me a mysql select statement to select all records since 'last sunday' i.e this week,  if my records have a field $datetime as type DATETIME?

 

is mysql even capable of doing this, i had a look at INTERVAL and CURTIME and stuff like that, but its just not going in. can anyone bail me out please?

[corbin]

Best I can think of is:

 

 

SELECT * FROM table WHERE column1 > SUBDATE(NOW(), INTERVAL 8 DAYS) AND DAYOFWEEK(column1) >= 1;

[fenway]

Since you know the current DAYOFWEEK() and the DAYOFWEEK() value for sunday, it's pretty easy use modulus to substract the correct number of days.

[fxr]

Best I can think of is:

 

 

SELECT * FROM table WHERE column1 > SUBDATE(NOW(), INTERVAL 8 DAYS) AND DAYOFWEEK(column1) >= 1;

 

 

yep.. that seems to have done it . thanks!

 

just it should be

 

SELECT * FROM table WHERE column1 > SUBDATE(NOW(), INTERVAL 8 DAY) AND DAYOFWEEK(column1) >= 1;