I am trying to query one of my MYSQL data bases.
The query below doesn't work:
SELECT *
FROM master_stock
WHERE symbol='BA' AND 'BAC' AND 'BMY'
AND dtime
BETWEEN '2009-09-08 9:30'
AND '2009-09-08 16:30'
The problem is in the Where command. This is the first time I have tried to retrieve multiple symbols fro the db at one time.
If I query for one symbol like - WHERE symbol='BA' the query returns the needed data.
Can anyone please help me with the correct syntax. Thank you very much.