#community-help

Querying Wildcards in a More Regex-y Way

TLDR Todd sought to use a more regex-like wildcard search. However, Jason clarified that only * or a keyword can be used due to performance issues.

Powered by Struct AI
Jun 14, 2022 (19 months ago)
Todd
Photo of md5-cccf0b87668408fef09dd77e1948fced
Todd
07:49 PM
With regard to the search stuff, I see we can supply a wildcard to indicate ‘match all strings’. Can we supply a wildcard in a more regex-y way?

I’d like to search something like prefix-*match*
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
07:53 PM
No unfortunately. It's just a * or a keyword
07:54
Jason
07:54 PM
Regex search is really hard to do in a performant way, because the list of strings it could match is infinite, and we'd essentially have to scan the whole dataset to find matches (which is similar to what LIKE %% does in SQL for eg)
Todd
Photo of md5-cccf0b87668408fef09dd77e1948fced
Todd
08:01 PM
Absolutely. Thank you for explaining. I’ll keep trying to figure out how best to search our data.