April 2008
Intermediate to advanced
566 pages
21h 55m
English
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.
Table B-3. Logical operators
Operator | Use |
|---|---|
| Logical AND |
| Logical AND |
| Logical equal |
| Logical equal |
| Logical OR |
| Logical OR |
| Logical NOT |
| Logical NOT |
| Logical XOR |
Read now
Unlock full access