要在日期之间获取记录,请使用BETWEEN。让我们首先创建一个表-mysql>createtableDemoTable863(StudentDateOfBirthdate);
使用插入命令在表中插入一些记录-mysql>insertintoDemoTable863values('1998-01-10');
mysql>insertintoDemoTable863values('2000-10-15');
mysql>insertintoDemoTable863values('-04-20');
mysql>insertintoDemoTable863values('-12-31');
mysql>insertintoDemoTable863values('1999-07-01');
使用select语句显示表中的所有记录-mysql>select*fromDemoTable863;
这将产生以下输出-+--------------------+
|StudentDateOfBirth|
+--------------------+
|1998-01-10|
|2000-10-15|
|-04-20|
|-12-31|
|1999-07-01|
+--------------------+
5rowsinset(0.00sec)
以下是查询以显示基于DOB的范围内的日期,即20 AND 21-mysql>select*fromDemoTable863where(YEAR(NOW())-YEAR(StudentDateOfBirth))BETWEEN20AND21;
这将产生以下输出-+--------------------+
|StudentDateOfBirth|
+--------------------+
|1998-01-10|
|1999-07-01|
+--------------------+
2rowsinset(0.03sec)