All Days in current Week Query

[oggl]

Hi there,

greetings from Germany. May you can help me. I need help to set up an SQL Query with the following conditions.

I need all Entrys created in This Week.

The Week starts with monday till friday.

Can you give me an SQL Query command ?

(SELECT * FROM MAIN WHERE DATE = {THIS WEEK}}

Thx for help

Brain

 

[TonyGroves]

How about:
[tt]
SELECT *
FROM main
WHERE
`date`
>=CURDATE()-INTERVAL WEEKDAY(CURDATE()) DAY
[/tt]
This returns all records with a `date` value of Monday or later. By the way, `date` is an SQL reserved word. You should change the field name to something non-reserved if possible.