Page 1 of 1

Logical Operator OR

Posted: Sat Oct 20, 2007 3:09 am
by ElArZ
Hey,

I'm having troubles figuring this out:
The functioning of OR in mysql is that it executes both conditions (before and after OR) and returns the result of both.

What I'm looking for is a way to be able to have the functionality of the php OR, meaning that only if the first condition is false, the second condition will be executed. If the first condition is true then the second one will not be executed.

Is there a way to achieve this?

Thank You.

Posted: Sat Oct 20, 2007 9:25 am
by aaronhall
I didn't know that mysql didn't short circuit (i'm a little surprised it doesn't), but if it doesn't, you'd have to resort to nested if statements.