unicode

Recent Blog Comments By unicode

• SQL AND / OR Order of Operations

  Posted on Aug 23, 2010 at 10:52 AM

  It's simple from the boolean logic point of view. AND is multiplication whereas OR is addition. AND: 1 AND 1 = 1 <=> 1 * 1 = 1 0 AND 1 = 0 <=> 0 * 1 = 0 etc. OR: 0 OR 0 = 0 <=> 0 + 0 = 0 0 OR 1 = 1 <=> 0 + 1 = 1 etc. The only exception is 1 OR 1 = 1 <=> 1 +... read more »