B.3. Logical Operators

Logical operators are used for evaluating values or expressions for true, false, or unknown. Table B-3 lists allowable logical operators.

Table B-3. Logical operators

Operator	Use
AND	Logical AND
&&	Logical AND
IS boolean	Logical equal
IS NOT boolean	Logical equal
OR	Logical OR
||	Logical OR
NOT	Logical NOT
!	Logical NOT
XOR	Logical XOR

The operators IS and IS NOT are being added in Version 5.0.2 of MySQL. A boolean value of trUE, FALSE, or UNKNOWN should immediately follow these operators.