Comparison Operators and null : Operator « Select Clause « SQL / MySQL






  1. SQL / MySQL
  2. Select Clause
  3. Operator

Comparison Operators and null

      
mysql>
Comparison operators normally return 1 (corresponding to TRUE) or 0 (FALSE).
Comparisons with NULL return NULL.
The two exceptions are the operators <=> and IS NULL, which even in comparison with NULL return 0 or 1:
mysql>
mysql> SELECT NULL=NULL, NULL=0;
+-----------+--------+
| NULL=NULL | NULL=0 |
+-----------+--------+
|      NULL |   NULL |
+-----------+--------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT NULL<=>NULL, NULL<=>0;
+-------------+----------+
| NULL<=>NULL | NULL<=>0 |
+-------------+----------+
|           1 |        0 |
+-------------+----------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT NULL IS NULL, NULL IS 0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1
mysql>
mysql>
mysql>








Related examples in the same category

1.Comparison Operators
2.Comparison operators 2
3.Arithmetic Operators
4.Sort Operators
5.special <=> operator, which is like = except that it works with NULL operands by treating them as any other va
6.Compare NULL with <=> operator
7.Not operator
8.or operator vs in operator
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