php - 从您的 MySQL 表中获取特定年龄段的人

Question

好吧，假设我有下表:

+----+-----------+--------+------------------+
| id | name      | gender | birthDate (date) |
+----+-----------+--------+------------------+
| 1  | John Doe  | Male   | 1968-09-18       |
| 2  | Jane Doe  | Female | 1970-11-20       |
| 3  | Sally Doe | Female | 1985-04-17       |
| 4  | Jake Doe  | Male   | 1989-07-10       |
| 5  | Mike Doe  | Male   | 1991-06-28       |
| 6  | Cindy Doe | Female | 1995-02-03       |
+----+-----------+--------+------------------+

我如何从这张表中找出年龄大于 21 岁且小于 50 岁的所有人。我通常可以在 mysql 中找到自己的方式，但在谈到日期时，我似乎总是搞砸了。

Answer 1

另一种使用 BETWEEN 语句的方法。

SELECT *
FROM tablename
WHERE birthdate BETWEEN
(curdate() - interval 50 year)
AND 
(curdate() - interval 21 year)