Using Logical AND Operator with NULL value : AND « Logic Operator « MySQL Tutorial

1. MySQL Tutorial
2. Logic Operator
3. AND

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

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

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

mysql>