> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Logical operators

| Operator | Expression & Description                                                              |
| :------- | :------------------------------------------------------------------------------------ |
| AND      | boolean1 AND boolean2  Logical AND.  TRUE if both *boolean1* and *boolean2* are TRUE. |
| OR       | boolean1 OR boolean2  Logical OR.  TRUE if either *boolean1* or *boolean2* is TRUE.   |
| NOT      | NOT boolean  Negates value.                                                           |

**Example**

| a     | b     | a AND b | a OR b | NOT a |
| :---- | :---- | :------ | :----- | :---- |
| TRUE  | TRUE  | TRUE    | TRUE   | FALSE |
| TRUE  | FALSE | FALSE   | TRUE   | FALSE |
| TRUE  | NULL  | NULL    | TRUE   | FALSE |
| FALSE | FALSE | FALSE   | FALSE  | TRUE  |
| FALSE | NULL  | FALSE   | NULL   | TRUE  |
| NULL  | NULL  | NULL    | NULL   | NULL  |