WHERE – IS NULL not working in SQLite?
a IS b and a IS NOT b is the general form where a and b are expressions. This is generally only seen in a IS NULL and a IS NOT NULL cases. There are also ISNULL and NOTNULL (also NOT NULL) operators which are short-hands for the previous expressions, respectively (they only take in … Read more