Suppose that value1 and value2 are dates, and that date is a date field in the database. This query:
WHERE date BETWEEN value1 and value2
returns all the rows where the date field is between value1 and value2.
What if I want to return all the rows where the date field goes just from value1 or just to value2? Is this possible using BETWEEN?