Mysql IS
From w3cyberlearnings
Contents |
MySQL IS Function
This functions tests against a boolean value. (Boolean value:TRUE, FALSE, or UNKNOWN).
Syntax IS
boolean: True, False, or Unknown
IS boolean;
Example 1
mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN; +-----------+------------+-----------------+ | 1 IS TRUE | 0 IS FALSE | NULL IS UNKNOWN | +-----------+------------+-----------------+ | 1 | 1 | 1 | +-----------+------------+-----------------+ 1 row in set (0.00 sec)
