微客导航 » 文章资讯 » 如何查询本周的MySQL？

如何查询本周的MySQL？

2024-04-27 00:06:05 415

要查询本周的MySQL，可以使用YEARWEEK()函数。

语法如下

SELECT *FROM yourTableName WHERE YEARWEEK(yourDateColumnName) = YEARWEEK(NOW());

为了理解上述语法，让我们创建一个表。创建表的查询如下

mysql> create table currentWeekDemo
   -> (
   -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   -> UserName varchar(20),
   -> UserPostDate date
   -> );

使用insert命令在表中插入一些记录。查询如下-

mysql> insert into currentWeekDemo(UserName,UserPostDate) values('Carol','2010-01-06');
mysql> insert into currentWeekDemo(UserName,UserPostDate) values('Bob','2019-06-04');
mysql> insert into currentWeekDemo(UserName,UserPostDate) values('David','2019-03-06');
mysql> insert into currentWeekDemo(UserName,UserPostDate) values('Maxwell','2018-04-21');

使用select语句显示表中的所有记录。查询如下-

mysql> select *from currentWeekDemo;

以下是输出

+--------+----------+--------------+
| UserId | UserName | UserPostDate |
+--------+----------+--------------+
|      1 | Carol    | 2010-01-06   |
|      2 | Bob      | 2019-06-04   |
|      3 | David    | 2019-03-06   |
|      4 | Maxwell  | 2018-04-21   |
+--------+----------+--------------+
4 rows in set (0.00 sec)

以下是如何在本周查询MySQL

mysql> select *from currentWeekDemo WHERE YEARWEEK(UserPostDate) = YEARWEEK(NOW());

以下是输出

+--------+----------+--------------+
| UserId | UserName | UserPostDate |
+--------+----------+--------------+
|      3 | David    | 2019-03-06   |
+--------+----------+--------------+
1 row in set (0.05 sec)

返回顶部
3162201930
czq8825@qq.com

如何查询本周的MySQL？

热门推荐

随机推荐