How to remove multiple keywords from a column

Question

I run

UPDATE mytable SET FruitsColumn = REPLACE(FruitsColumn,'apple','')

it works fine and removes every instance of the word "apple" from my column.

But how can I remove an apple, as well as other words at the same time?

I tried

UPDATE mytable SET FruitsColumn = REPLACE(FruitsColumn,'apple,orange,strawberry','')

and it does not work

Answer 1

you need to make nested REPLACE calls:

UPDATE mytable SET FruitsColumn =
REPLACE(REPLACE(FruitsColumn,'orange',''),'apple','')