When I’m still learning SQL, I came to a point when I asked myself that if sql use “IN” argument shouldn’t it also use “NOT IN” statement. So I googled and found no direct confirmation or example (this one is a little bit advance for me way back then). Not even on w3schools or tizag tutorials for sql.
But hey, I wrote this post to say that sql “NOT IN” arguments works. Try it !
SELECT *
FROM MyTable
WHERE MyField NOT IN (‘value1′,’value2′,’value3′);
Happy programming !

No related posts.