Sqlite NOT IN Syntax Sqlite NOT IN Syntax sqlite sqlite

Sqlite NOT IN Syntax


Basics of boolean algebra https://en.m.wikipedia.org/wiki/De_Morgan%27s_laws

id in(x1,x2,...xn) meansid = x1 or id = x2 or ... id = xnid not in(x1,x2,...xn) meansid <> x1 and id <> x2 and ... id <> xnnot id in(x1,x2,...xn) meansnot(id = x1 or id = x2 or ... id = xn) that meansnot(id = x1) and not(id = x2) and ... not(id = xn) that meansid <> x1 and id <> x2 and ... id <> xn

So they are the same.