Select Between Dates

[jnull]

I have the following select statement:

 

SELECT * FROM `events` WHERE `Category` = "one" OR `Category` = "two" OR `Category` = "three" AND (`StartDate` BETWEEN "2011-06-30" AND "2011-07-05") ORDER BY `Category`

 

It returns data for all date ranges in the categories specified, which is incorrect.

 

If I only have

 

SELECT * FROM `events` WHERE `StartDate` BETWEEN "2011-06-30" AND "2011-07-05" ORDER BY `Category`

 

it returns nothing which is correct response.

 

Can you give me any idea of what's up with the first select statement?

 

[AMcHarg]

Try this:

SELECT * FROM `events` WHERE (`Category` = "one" OR `Category` = "two" OR `Category` = "three") AND (`StartDate` BETWEEN "2011-06-30" AND "2011-07-05") ORDER BY `Category`

[jnull]

Thank you ... just perfect!