special <=> operator, which is like = except that it works with NULL operands by treating them as any other va : Operator « Select Clause « SQL / MySQL






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)

   
    
    
    
    
    
  








Related examples in the same category

1.Comparison Operators
2.Comparison operators 2
3.Arithmetic Operators
4.Sort Operators
5.Compare NULL with <=> operator
6.Not operator
7.or operator vs in operator
8.Comparison Operators and null
9.Use the basic mathematical operators
10.In operator and a long list of integer
11.Less than and equals(<=) operators with All operator
12.Reversing or Negating Query Conditions
13.Not equal