[Archer36]

Im sure there is a way to do this but, does anyone know how to make MySQL do a query between two dates? Lets say I want to query all messages posted between July 20 - July 22 but none others? BTW I am doing this in php too.

Thanks

[shortyes]

Just set the where statement to be x>July 20 and x < july 22

[Archer36]

Oh ok I thought about doing that but it just did not seem to be right.

[Krieger]

Yeap that's the way it works... seems odd, but it makes the most sense when you think about it.

[Archer36]

Yea it works great too, thanks!

[marker]

There is usually a "BETWEEN" predicate which makes the query a little cleaner:

SELECT *
FROM Orders
WHERE (OrderDate BETWEEN '1/1/2004' AND '12/31/2005')

[Archer36]

Originally Posted by marker

There is usually a "BETWEEN" predicate which makes the query a little cleaner:

SELECT *
FROM Orders
WHERE (OrderDate BETWEEN '1/1/2004' AND '12/31/2005')

Great, ill give that a shot too, it looks more fitting for what the query to do. Thanks!

Just one question, before I change to the new code I am using two variables in place of the two dates, I am assuming this would work the same just making sure before I change it.

[marker]

Should work with variables, I do it all the time. However, my expertise is in MS SQL Server not MySQL, but I cannot imagine why it would function any differently.