How to select data from the database by year of birth when the date is stored in the format "DD / MM / YYYY" using SQL?

Question

PHP

There is a base that stores dates of birth in the above format.
It is necessary to pull out, for example, lines where the year of birth is from 1990 to 1995.
Can this be done somehow without unloading all the data, that is, using SQL tools?

Answer 1

in general, I solved my problem a little differently
select * from t where STR_TO_DATE(t.date, '%d/%m/%Y') BETWEEN '1990-01-01' AND '1995-01-01'