in mysql how can i show people who are over 40 years old. I have a column that contains birth dates.
Loading
in mysql how can i show people who are over 40 years old. I have a column that contains birth dates.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vishal YelvePosted Aug 3, 2022, 6:52 AM
Rajanikant HawaldarPosted Aug 3, 2022, 5:52 AM
Try,
Select personname, dob from persontable where dob <= date_sub(NOW(), INTERVAL 40 YEAR);