top of page
68
MySQL 8.0
IS
Syntax:
IS boolean_value
Tests a value against a boolean value, where boolean_value can be TRUE,
FALSE, or UNKNOWN.
mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
-> 1, 1, 1
bottom of page
MySQL 8.0
Syntax:
IS boolean_value
Tests a value against a boolean value, where boolean_value can be TRUE,
FALSE, or UNKNOWN.
mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
-> 1, 1, 1