Ok, so if I'm reading you right, you need to build an IN clause which would read
Code:
IN ('oranges', 'apples', 'pears', 'peaches')
With the SELECT whatever FROM whatever WHERE product etc.

Is this right?