IS 'boolean_value': Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN : IS « Comparison Functions Operators « MySQL Tutorial






mysql>
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)

mysql>








15.10.IS
15.10.1.IS 'boolean_value': Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN
15.10.2.IS NOT 'boolean_value': Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN