Replace string value in entire table

Hello Altrusits,   I have table from where I want to remove 'apple'.  apple may come with additional character. How can I remove only 'apple' from table . Thanks in advance.     Fruit appl...