How to write a request with BETWEEN?

Question

PHP

The database has 2 fields with dates. The from and to fields contain dates from and to , such as 20150517 and 20150520 .
I send two dates in the form, and those users who enter the specified period are shown.

Answer 1

Already figured out, you can delete the question), and if not, maybe someone will come in handy.

SELECT * FROM student WHERE DATE(from_date) >= '2015-05-01' AND DATE(to_date) <= '2015-05-23'

Answer 2

SELECT * FROM `student` WHERE (from_date BETWEEN '2015-05-01' AND '2015-05-23') AND (to_date BETWEEN '2015-05-01' AND '2015-05-23');