Posted by Steve on 02/23/06 21:56

> How can I write a MySQL statement that asks "give me all trips between
> (and including) the first day of March, 2006 and the last day of March,
> 2006?"

It would help to see the definitions for the tables involved. However,
this is roughly what you need, adapt as required...

SELECT *
FROM trips
WHERE startdate BETWEEN '20060301' AND '20060331'

---
Steve

[Back to original message]