Newbie OR question

[harvillo]

I have several items in a database separated BY unique ID's (about 10). I want some users to be able to view limited amounts of data based on the ID. I can separate them by using OR statements (i.e. view where ITEM_ID=1 OR ITEM_ID=5) store the OR statements in a database and register them but it seems so messy to have 10 OR statements especially if the unique ITEM_ID's go up to 20..or 30...

In other words

ITEM_ID=1 Item=apple
ITEM_ID=1 Item=apple
ITEM_ID=1 Item=apple

ITEM_ID=2 Item=apple
ITEM_ID=2 Item=apple
ITEM_ID=2 Item=apple

ITEM_ID=3 Item=apple
ITEM_ID=3 Item=apple
ITEM_ID=3 Item=apple

I only need a user to view where ITEM_ID=1 OR ITEM_ID=3.

Perhaps where ITEM_ID!=2?

[bastien]

yes, that will work

also consider not in (value1,value2..valueN) exclusion

or in (value1,value2..valueN) inclusion

or [not] between value1 and value2 range