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*
j
Jason Bosco
06/14/2022, 7:53 PM
No unfortunately. It's just a
*
or a keyword
Jason Bosco
06/14/2022, 7: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)
t
Todd Tarsi
06/14/2022, 8:01 PM
Absolutely. Thank you for explaining. I’ll keep trying to figure out how best to search our data.