not

The NOT operator. Return the negation of the provided value.

  NOT <value>

<value>

The boolean value to negate

TRUE

If the value is FALSE.

FALSE

If the value is TRUE.

NULL

If the value is NULL.

SQL_CONTAINS('foo') AND SQL_CONTAINS('bar')