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

Question

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月，请问如何做语句，谢谢~~

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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