MySQL date calculation and selecting greater than 55

Question

I have calculated age from date of birth but I would like to select greater than 55 only in a stored procedure. Below is what I have done.

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 has an extension where you can use having for this purpose:

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

Answer 2

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