filterByFormula contains or like

[SynopsisLabs]

Hi,

I want to search for 1 item in a table which contains multiple items in a cell - apple, banana, grape.

The filterByFormula with the = only works if there is only 1 item in the cell.  If they are multiple items, I get an error.

I tried using "contains" and "like" but they don't work.  

What should I use?

Thanks

Steve

[SynopsisLabs · Accepted solution]

No worries - found an answer - 

?filterByFormula=REGEX_MATCH({column_name, "apple")