compare column value to anything in a list of values

[Bryan Cantwell]

Is there a simple function or method to compare a value in a column to one or more items
in a comma separated list?

select * from table where value <contains one of> ('apple','orange','banana');

and say value may = something like 'produce(grape,orange,pear,apple,lettuce)'