where is used to compare fields and search is used to compare a field to a value. You can only evaluate one function with the where. You can do multiple with a search
That's not true. You can use multiple conditions in a where clause. You can do | where like(field,"%value%") AND field2<$token$ AND match(field3,"<regex>")...
... View more