Select Clause MySQL

  1. Home
  2. MySQL
  3. Select Clause
  4. Special = operator, which is like = except that it works with NULL operands by treating them as any other va
lue
mysql>
mysql>
mysql> SELECT 1 <=> NULL, 0 <=> NULL, NULL <=> NULL;
+------------+------------+---------------+
| 1 <=> NULL | 0 <=> NULL | NULL <=> NULL |
+------------+------------+---------------+
|          0 |          0 |             1 |
+------------+------------+---------------+
1 row in set (0.00 sec)