Logical Operator OR

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ElArZ
Forum Newbie
Posts: 2
Joined: Wed Sep 12, 2007 2:20 pm

Logical Operator OR

Post 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.
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post 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.
Post Reply