Топ-100
 

IS NOT

RDBMS Type: MySQL
Topic

Syntax:
IS NOT boolean_value

Tests a value against a boolean value, where boolean_value can be TRUE,
FALSE, or UNKNOWN.

URL: https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html

Example

mysql> SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;
-> 1, 1, 0