hello; is there a way of doing regular expression ...
# fleet
t
hello; is there a way of doing regular expression matching when doing a query? (LIKE "%foo%" matching is too greedy for me 🙂)
k
Hi @Tor Houghton! osquery supports regex_match, the syntax for that would be something like this:
Copy code
SELECT * from <table> WHERE regex_match(<column>, <expression>, 0) IS NOT null;
t
Ah! Thank you, I'll give this a go!