Logical Operators : Introduction « Logic Operator « MySQL Tutorial






  1. MySQL Tutorial
  2. Logic Operator
  3. Introduction
NameDescription
AND, &&Logical AND
NOT, !Negates value
||, ORLogical OR
XORLogical XOR


In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN).

In MySQL, these are implemented as 1 (TRUE), 0 (FALSE), and NULL.

8.1.Introduction
8.1.1.Logical Operators
8.1.2.Logical operator with parenthesis