Find specific word within a text cell

Hi all,

I have a column with cells containing a lot of text.

I would like to create a column which looks for a certain word and return a specific value.

1. 

For instance if I was to look for Apple -> return 'Yes' or 'No'

Can I make the code look for *app*' or does it need to be fully matching?

I would like to have to return entries like 'apple-like' for instance, or or 'apples'

I hope this makes sense, right now I'm using the 'add a conditional column' in the query, which is fine, but not taking all possibities into account.

Thanks

Kristoffer