From the documentation:
<=>
Null safe equal:
mysql> select 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
-> 1 1 0
But when I try it:
mysql> select NULL <=> NULL;
ERROR 1064: ^GYou have an error in your SQL syntax near '> NULL' at line 1
What's going on here?
Yoseif Whiteson
<=>
Null safe equal:
mysql> select 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
-> 1 1 0
But when I try it:
mysql> select NULL <=> NULL;
ERROR 1064: ^GYou have an error in your SQL syntax near '> NULL' at line 1
What's going on here?
Yoseif Whiteson