如何在MySQL中搜索具有yyyy-mm-dd结构且仅与特定yyyy格式（年份）进行比较的dob表格？

为此，使用MySQL YEAR()语法如下−

select * from yourTableName where year(yourColumnName)=’yourYearValue’;

让我们首先创建一个表−

mysql> create table DemoTable1322
-> (
-> DOB date
-> );
Query OK, 0 rows affected (0.55 sec)

阅读更多：MySQL 教程

示例

使用insert命令在表中插入一些记录−

mysql> insert into DemoTable1322 values('1999-04-12');
Query OK, 1 row affected (0.68 sec)
mysql> insert into DemoTable1322 values('2010-12-01');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable1322 values('2015-03-09');
Query OK, 1 row affected (0.25 sec)
mysql> insert into DemoTable1322 values('2007-05-24');
Query OK, 1 row affected (0.08 sec)

使用select语句从表中显示所有记录−

mysql> select * from DemoTable1322;

输出

+------------+
| DOB        |
+------------+
| 1999-04-12 |
| 2010-12-01 |
| 2015-03-09 |
| 2007-05-24 |
+------------+
4 rows in set (0.00 sec)

示例

以下是搜索yyyy-mm-dd结构的dob的查询。 我们与yyyy即一个特定年份进行比较−

mysql> select * from DemoTable1322 where year(DOB)='2015';

输出

+------------+
| DOB        |
+------------+
| 2015-03-09 |
+------------+
1 row in set (0.01 sec)