mysql - 选择从出生日期起年龄在 35 - 50 之间的地方

Question

嗨，我想从出生日期列中年龄在 30-50 之间的表中选择数据。

SELECT * FROM
   (SELECT FLOOR((CAST (GetDate() AS INTEGER) - CAST(dob1 AS INTEGER)) / 365.25) AS Age, * 
   from tbl_travelins) as tbl_travelins
WHERE Age >= 30 AND Age < 50

标签： mysql

Answer 1

尝试使用TIMESTAMPDIFF：

SELECT *
FROM tbl_travelins
WHERE TIMESTAMPDIFF(YEAR, dob1, CURDATE()) BETWEEN 30 AND 49;