Find Rows whose date range contain a given date

Question

Hello,

I am looking at the following problem:

My group table contains two fields: ArrivalDate and DepartureDate.

Now I want to find all groups who are present at a given date.

Eg. the SQL query is passed a date, and I want to find every group where this date falls into the range ArrivalDate to DepartureDate.

Thanks a lot! Martin

Answer 1

SELECT
  ...
FROM
  yourGroupTable as y
WHERE
  Curdate() BETWEEN y.ArrivalDate AND y.DepartureDate

replace Curdate() by your actual date value.