如何选择年龄范围内的人 [英] how SELECT people within age range

问题描述

我已经尝试了所有其他问题/解决方案，但没有答案.所以在这里是:我需要SELECT * FROM people WHERE(DOB是18到40)

I've already tried all other questions/solutions, and no answer. so here it is: I need to SELECT * FROM people WHERE (dob is 18 to 40)

但是我的Dob存储为DATE类型YYYY-MM-DD

but my dob is stored as DATE type YYYY-MM-DD

例如，需要选择18至40岁的人！

need to select people between 18 and 40 for example!

推荐答案

您需要使用BETWEEN进行某些年份的计算TIMESTAMPDIFF(YEAR,'1980-02-04',NOW())

You need to use BETWEEN with some year calculation TIMESTAMPDIFF(YEAR,'1980-02-04',NOW())

SELECT * FROM people WHERE TIMESTAMPDIFF(YEAR,`dob`,NOW()) BETWEEN  18 AND 40

在此处查看小提琴

TIMESTAMPDIFF

年份(日期)

这篇关于如何选择年龄范围内的人的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！