Using Logical OR operator with NULL value : OR : Logic Operator MySQL TUTORIALS

MySQL TUTORIALS » Logic Operator » OR »

Using Logical OR operator with NULL value


mysql>
mysql> SELECT 0 || NULL;
+-----------+
| 0 || NULL |
+-----------+
|      NULL |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT 1 || NULL;
+-----------+
| 1 || NULL |
+-----------+
|         1 |
+-----------+
1 row in set (0.02 sec)

mysql> SELECT NULL || NULL;
+--------------+
| NULL || NULL |
+--------------+
|         NULL |
+--------------+
1 row in set (0.00 sec)

mysql>
mysql>