baisc syntax question - not in (1,2,3)
Posted: Sun Dec 31, 2006 9:28 am
What's the syntax for geting al the rows which col_a not in a list of values?
should be something like
or
or
should be something like
Code: Select all
select * from table where id not in (2, 5, 1, 7);Code: Select all
select * from table where id ~in (2, 5, 1, 7);Code: Select all
select * from table where id !in (2, 5, 1, 7);