Page 1 of 1

baisc syntax question - not in (1,2,3)

Posted: Sun Dec 31, 2006 9:28 am
by pedrotuga
What's the syntax for geting al the rows which col_a not in a list of values?


should be something like

Code: Select all

select * from table where id not in (2, 5, 1, 7);
or

Code: Select all

select * from table where id ~in (2, 5, 1, 7);
or

Code: Select all

select * from table where id !in (2, 5, 1, 7);

Posted: Sun Dec 31, 2006 9:28 am
by feyd
Have you tried them?

Posted: Sun Dec 31, 2006 9:32 am
by pedrotuga
:oops: :oops: :oops: :oops: :oops:

mods, please delete this thread