mysql filter based on datediff
snippet in sql

mysql filter based on datediff

user7558

SELECT *
FROM myTable
WHERE birthdate >= 'date1' AND death <= 'date2' AND age > 17 AND age < 55;