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 "%"?
Use the match
function. It takes regular expressions.
| where match(myField, "match % this")
Docs here.
Using search instead of where will give you the solution, here.
| search myfield="match % this"
Use the match
function. It takes regular expressions.
| where match(myField, "match % this")
Docs here.