Need to escape % using LIKE.

[dawfun]

In my where command I need to use LIKE to match a string containing %. Something like this:

... | where LIKE(myField, "match % this") | ...

I need a literal match on "match % this", to exclude something like "match other things but not this".

So, any thoughts on how to find a literal "%"?

[ldongradi_SPL]

Using search instead of where will give you the solution, here.

| search myfield="match % this"

[aljohnson_splun · Accepted solution]

Use the match function. It takes regular expressions.

| where match(myField, "match % this")

Docs here.