如何通过 MySQL 查询使用 BirthDate 列获取年龄?

2021-12-29 00:00:00 date php mysql zend-framework

我在 MySQL 数据库表中有一个 BirthDate 列来存储用户的出生日期.现在我在 html/php 中有两个字段的表单(1.年龄从 2.年龄到).

I have a BirthDate column in MySQL database table to store user's date of birth. Now I have form in html/php with two fields(1. Age From 2. Age To).

如果用户想要获取年龄在 10 岁到 20 岁之间的所有用户，是否可以使用 BirthDate 列通过 MySQL 查询来执行此操作.

If user want to get all users where their ages are between 10 years and 20 years, Is it possible to do this with MySQL query using BirthDate column.

谢谢

推荐答案

您的查询将类似于:

SELECT * FROM your_table WHERE YEAR(CURDATE())-YEAR(BirthDate) BETWEEN 10 AND 20;

相关文章