What is the equivalent of the null safe equality operator <=> in SQLite?

I need to define what is the equivalent for the SQLite <=> operator in MySQL.

Any idea?


source share

2 answers

The IS and IS NOT operators work like = and! = Except when one or both of the operands are NULL. In this case, if both operands are NULL, then the IS operator evaluates to 1 (true) and the IS NOT operator evaluates to 0 (false)




I just found the "IS" operator, but not sure if it has exactly the same behavior?



All Articles