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

Question

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?

+3

null database mysql sqlite operator-keyword

Erwin mayer 11 Mar 12 at 19:24

source share

2 answers

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

+2

Erwin mayer 11 Mar 12 at 19:27

source share

Neysor · Accepted Answer · 2012-03-11T19:29:24+0000

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)

http://www.sqlite.org/lang_expr.html#isisnot

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

More articles: