MySQL日期计算和选择大于55

Question

我已经从出生日期计算出年龄，但我只想在存储过程中选择大于 55 的年龄。以下是我所做的。

DELIMITER //
CREATE PROCEDURE p6()
BEGIN
SELECT Firstname, Lastname, telephone_number, TIMESTAMPDIFF(YEAR,DOB,CURDATE())  AS age
FROM Staff
WHERE Job_title = 'instructor';

END //
DELIMITER ;

Answer 1

MySQL 有一个扩展，您可以在其中使用 having 来达到这个目的:

SELECT Firstname, Lastname, telephone_number,
       TIMESTAMPDIFF(YEAR, DOB, CURDATE())  AS age
FROM Staff
WHERE Job_title = 'instructor'
HAVING age > 55;