Retrieving dates that fall within two specified dates

Question

I am storing the start and end date of a users holiday period in a MySQL table.

I need to enable the ability for administrators to run reports where they specify two dates and all users who's start date or end date fall in between the two specified dates are retrieved from the database.

Has anyone done anything similar, or know of a good method of doing this?

Answer 1

use mysql's between operator