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

• Next in forum: Re: Joining many results from one table with one result from another in one query
• Prev in forum: Re: Using PHP to Connect to a Remote MySQL Server
• Thread view: Re: Getting an MySQL first day and last day statement

[Reply to this message]