Mega Code Archive

 

Categories / MySQL / Select Clause

 

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)