Logical Operators
Logical operators are used for evaluating values or expressions for true, false, or unknown. Table B-3 lists allowable logical operators.
The operators IS
and IS NOT
are added in version 5.0.2 of MySQL. A boolean value of
TRUE
, FALSE
, or
UNKNOWN
should immediately follow these
operators.
Operator | Use |
| Logical AND |
| Logical AND |
| Logical equal |
| Logical equal |
| Logical OR |
| Logical OR |
| Logical NOT |
| Logical NOT |
| Logical XOR |
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.