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.

Throw some parentheses around the OR conditions.

walkingTarget
– walkingTarget

2011-04-15 14:45:43 +00:00
Commented Apr 15, 2011 at 14:45 — walkingTarget
– walkingTarget, Commented Apr 15, 2011 at 14:45

Emil Vikström · Accepted Answer · 2011-04-15 14:44:57Z

30

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

answered Apr 15, 2011 at 14:44

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jeroen · Accepted Answer · 2011-04-15 14:45:40Z

9

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

edited Apr 15, 2011 at 14:45

answered Apr 15, 2011 at 14:44

jeroen

91.8k22 gold badges118 silver badges132 bronze badges

1 Comment

Drew Over a year ago

Agreed with Dan above... I feel dumb, but it's EXACTLY what I was looking for. Thanks as well.

Jan Zyka · Accepted Answer · 2011-04-15 14:46:32Z

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

answered Apr 15, 2011 at 14:46

Jan Zyka

18k18 gold badges75 silver badges120 bronze badges

Comments

dcai · Accepted Answer · 2011-04-15 14:47:30Z

2

you should use IN Operator

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

edited Apr 15, 2011 at 14:47

answered Apr 15, 2011 at 14:46

dcai

2,5553 gold badges20 silver badges37 bronze badges

Comments

Alfred · Accepted Answer · 2011-04-15 14:50:58Z

2

Try grouping

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

answered Apr 15, 2011 at 14:50

Alfred

21.5k64 gold badges175 silver badges258 bronze badges

Comments

Benjamin A · Accepted Answer · 2011-04-15 14:51:24Z

2

You could try something like this...

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

if you don't want to use IN you can also do this...

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

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in

answered Apr 15, 2011 at 14:51

Benjamin A

531 silver badge4 bronze badges

Collectives™ on Stack Overflow

using "OR" and "AND" mysql php

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related