8. 2. 1. Logical AND(AND, &&) |
|
Evaluates to 1 if all operands are non-zero and not NULL. |
Evaluates to 0 if one or more operands are 0. |
Otherwise NULL is returned. |
mysql>
mysql> SELECT 1 && 1;
+--------+
| 1 && 1 |
+--------+
| 1 |
+--------+
1 row in set (0.00 sec)
mysql> SELECT 1 && 0;
+--------+
| 1 && 0 |
+--------+
| 0 |
+--------+
1 row in set (0.00 sec)
mysql>
|
|