[RESOLVED] Update query question

I know that if you use the following code...

UPDATE
table
SET
field = ""
WHERE
field1 = ""

than it will change field in all records that meet the criteria of field1

What I need to know is there a way to update all records that meet only a part of field1

ie...

UPDATE
table
SET
field = "yummy"
WHERE
field1 = "apples|oranges"

if field one contains apples|oranges|grapes

it would still pick up that record...

hopefully this makes sence....

Thanks....

field1='apples' OR field1='oranges' OR field1='pears'

But looking at your post again, I think you have a list of values in field1, so just use LIKE instead of =

field1 LIKE 'apples' OR field1 LIKE 'oranges

Just to clarify RR's response:
UPDATE table
SET field = "yummy"
WHERE
(field1 LIKE '%apples%' OR field1 LIKE '%oranges%')

adding the wild card will find substrings 'apples' and 'oranges'

That did it....

thanks guys