Logic Operator MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Logic Operator
  4. Logical Operators
Name Description
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.