[RESOLVED] sql query for count records of current week

[Pulsorock]

Hello,

I have a registration form that saves the registration date on a datetime column. I would like make a query to know how many records are in the table that where for the current week. For example, I'm on week 25 and I want to know how many records I have for this week without the need of specifying the from and to dates. Is there a way to do this?

Thanks!

[Pulsorock]

I found it

WHERE YEARWEEK(regdate) = YEARWEEK(CURRENT_TIMESTAMP)

[devinemke]

SELECT COUNT(*) FROM table WHERE WEEK(date) = WEEK(CURDATE())

[bradgrafelman]

Don't forget to mark this thread resolved.