Просмотр исходного текста страницы MySQL Tutorial/Comparison Functions Operators/NULL safe equal

== NULL-safe equal :<=>==

<p>NULL-safe equal(<=>) performs an equality comparison like the = operator.</p>
<p>NULL-safe equal(<=>) returns 1 rather than NULL if both operands are NULL.</p>
<p>NULL-safe equal(<=>) returns 0 rather than NULL if one operand is NULL.</p>


   
  <!-- start source code -->
   
    <source lang="sql">
mysql>
mysql> SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
+---------+---------------+------------+
| 1 <=> 1 | NULL <=> NULL | 1 <=> NULL |
+---------+---------------+------------+
|       1 |             1 |          0 |
+---------+---------------+------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 1 = 1, NULL = NULL, 1 = NULL;
+-------+-------------+----------+
| 1 = 1 | NULL = NULL | 1 = NULL |
+-------+-------------+----------+
|     1 |        NULL |     NULL |
+-------+-------------+----------+
1 row in set (0.00 sec)
mysql></source>