using "OR" and "AND" mysql php

Question

I have a MySQL query, where I want to get a value, lets say m that can be 'x', 'y' or 'z' and two other variables which need to be exact values. I don't know how to write this.

I don't know if you get the idea, but this is what I have:

SELECT * FROM respuestas 
WHERE id_curso = '155' OR id_curso = '156' OR id_curso= '157' OR id_curso= '158' 
AND id_pregunta='1' AND respuesta>=0

So I need id_curso to be 155 or 156 or 157 or 158 and at the same time, id_pregunta = 1 and respuesta > 0.

I know this is not the way to write it, but I don't know the right way.

Answer 1

Try this:

WHERE
  id_curso IN('155', '156', '157', '158') AND
  id_pregunta = '1' AND
  respuesta >= 0

Or, if you prefer your verbose way, use a parenthesis:

WHERE
  (id_curso = '155' OR
   id_curso = '156' OR
   id_curso = '157' OR
   id_curso = '158') AND
  id_pregunta = '1' AND
  respuesta >= 0

If id_curso is an integer (which it doesn't seem to be by your query since you've used quotation marks, but here goes anyway), you can even use the BETWEEN keyword to select a range of values:

WHERE
  (id_curso BETWEEN 155 AND 158) AND
  id_pregunta = '1' AND
  respuesta >= 0

Answer 2

You need to group your OR statements so that they form one condition:

SELECT * FROM respuestas WHERE (id_curso= '155' OR id_curso= '156' OR id_curso= '157' OR id_curso= '158') AND id_pregunta='1' AND respuesta>=0

Answer 3

AND has higher priority than OR, you need to use brackets:

SELECT * FROM respuestas WHERE (id_curso= '155' OR id_curso= '156' OR id_curso= '157' OR id_curso= '158') AND id_pregunta='1' AND respuesta>=0 

Answer 4

you should use IN Operator

SELECT * FROM respuestas WHERE id_curso IN (155, 156, 157, 158) AND id_pregunta='1' AND respuesta>=0