MYSQL 如何统计本周以及本月数据

[cnhzlyg]

MYSQL 如何统计本周以及本月数据？

例如：有这样一张表 ID（ID） , DATETIME(日期时间) ,TEXT（内容）
1 , 2007-11-08 07:20:53 ,“HELLOWORLD"
2 , 2007-11-09 06:20:53 ,“HELLOWORLD2"
3 , 2007-11-10 06:20:53 ,“HELLOWORLD3"
4 , 2007-12-08 06:20:53 ,“HELLOWORLD4"
5 , 2007-12-09 06:20:53 ,“HELLOWORLD5"
现在要统计当前周的数据，和当前月的数据.假设当前月为11月，请问如何做语句，谢谢~~

[懒得去死]

SELECT   *   FROM   tablename 
WHERE   WEEKOFYEAR(datetime)=WEEKOFYEAR(now());
SELECT   *   FROM   tablename 
WHERE   month(datetime)=month(now());

[yangbinkk]

SELECT * FROM tablename
WHERE YEAR(datetime)=YEAR(CURDATE()) AND MONTH(datetime)=MONTH(CURDATE());

[yangbinkk]

SELECT * FROM tablename
WHERE WEEKOFYEAR(datetime)=WEEKOFYEAR(CURCOUNT());

[yangbinkk]

SELECT * FROM tablename
WHERE EXTRACT(YEAR_MONTH FROM datetime)= EXTRACT(YEAR_MONTH FROM CURDATE());