MySQL query not working right...

[DoD]

i'm using the following query, at the moment... but the WHERE clause isnt working right...

SELECT * FROM forums_snn_topics WHERE topic_id = 999 AND topic_type = '0'  OR topic_type = '1' OR topic_type = '2'

This wont give me what i want... i want the query to be, WHERE topic_id = 999 AND (WHERE topic type = 0 OR 1 OR 2) but when i process the query above, it returns (WHERE topic_id = 999 AND topic_type = '0') OR topic_type = 1 etc etc

any help?

[onyx]

Its is due to the presidence of the AND and OR operators. AND shows presidence over OR so you need to use brackets.

SELECT * FROM forums_snn_topics WHERE topic_id = 999 AND (topic_type = '0'  OR topic_type = '1' OR topic_type = '2')

[DoD]

Aaaah! Works a treat! Tried using brackets but i did em wrong by putting it infront of the AND.

Thanks for the help!!