SELECT * between two specific dates

[stojan]

Hi, I need to pull out all records from database where date is in between two specified dates, e.g. between 1. january - 1. february. So what would be my SQL query to do that ? Thanx.

[Merve]

Select all of them and use PHP to pull out the ones you need.

[stojan]

And how do I do that ?
I know just to pull all records where date is > or < than entered, but how to pull between specified dates ? Any help is appriciated.

[Cheers]

You can specify multiple criteria for a given column with MYSQL

So,
When looking for values between you could use an 'AND' like so...

select * from table where datestamp > '2003-01-01' and datestamp < '2003-02-01'

BUT!!! A much neater way is to use 'BETWEEN' like so...

select * from table where datestamp between '2003-01-01' and '2003-02-01'

Hope this helps

-Cheers