MYSQL Query

[jamison]

Yes, I really do want to do this and thank you for your reply. However, I am getting some unusual results. My query is
SELECT *
FROM master_stock
WHERE symbol = 'BA'
OR symbol = 'BAC'
OR symbol = 'BMY'
OR symbol = 'CAT'
AND dtime
BETWEEN '2009-09-08 9:00'
AND '2009-09-08 17:00';

The last symbol is dropped from the report and the report begins at the first day of the data base, not on Sept, 8th. Any ideas. I really appreciate the help.

[Dmitriy]

This one is complete correct example

 SELECT * 
FROM master_stock
WHERE 
(symbol = 'BA' OR 
symbol = 'BAC' OR 
symbol = 'BMY' OR 
symbol = 'CAT') AND 
dtime BETWEEN '2009-09-08 9:00' AND '2009-09-08 17:00' 
  

For simplycity I'd suggest you omit BETWEEN and use only logic operands

 SELECT * 
FROM master_stock
WHERE 
(symbol = 'BA' OR 
symbol = 'BAC' OR 
symbol = 'BMY' OR 
symbol = 'CAT') AND 
dtime >= '2009-09-08 9:00' AND 
dtime <= '2009-09-08 17:00' 
  

The trick is in brackets where you put your OR's.