How do you filter by dates in a database?

Question

MySQL

I'm doing this for the first time please tell me how to reproduce the search by dates
like this I want it to find me records that have years from 2015 to 2020 how should I do?

Go through the for loop and collect records as for me is not an option, can there be a request for this?

SELECT * FROM `items` WHERE `date` = '2015-01-01'

Answer 1

yes there is a request for that. you can use comparison signs, you can master BETWEEN.