mysql查询本周的数据

SELECT create_time FROM user WHERE YEARWEEK(date_format(create_time,'%Y-%m-%d'),1) = YEARWEEK(now(),0);

看的这位大神的博客，亲测可用:https://blog.youkuaiyun.com/Lijunhaodeboke/article/a/90900091

如果有需要查询其他类型的数据，可查看这篇博客，本人未测，感觉有些需要再细化一点：https://blog.youkuaiyun.com/qq_22067469/article/details/90321979