MySQL - Select greater than Or a specific value

Question

This is a simple question but I'm getting stuck on it. Basically I need to add in the following AND statements to a query:

AND  a.d_max > '0' AND  a.max > '0'

BUT I would also like to make it so the max is either greater than 0 or = u because if it's set to u it means unlimited. So something like:

AND  a.d_max > '0' OR a.d_max = u AND  a.max > '0' OR a.max = u

How would I go about doing this?

Is u a field name or a constant? Note, that you may actually want to use > 0, not > '0' because = 'u' is also > '0'. — Marcus Adams
– Marcus Adams, Commented Mar 12, 2013 at 17:13

mellamokb · Accepted Answer · 2013-03-12 16:56:07Z

2

I think your logic is ok, but you're just missing some parentheses:

AND
  (a.d_max > '0' OR a.d_max = u) AND (a.max > '0' OR a.max = u)

answered Mar 12, 2013 at 16:56

mellamokb

56.9k12 gold badges111 silver badges138 bronze badges

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

Comments

Abubakkar · Accepted Answer · 2013-03-12 17:00:26Z

0

You can prioritize the evaluation of expressions/conditions using paranthesis:

In you case, I think you need this :

AND  (a.d_max > '0' OR a.d_max = u) AND  (a.max > '0' OR a.max = u)

answered Mar 12, 2013 at 17:00

Abubakkar

15.7k8 gold badges58 silver badges84 bronze badges