On 28 Feb 2020, at 11:02pm, Hamish Allan <ham...@gmail.com> wrote: > What I'm wondering is if there's a shortcut to avoid having to build the UUID > list in app code
I would probably start by building a list of the search patterns then see what I could do with it: (pattern1,pattern2,pattern3) Would a Common Table Expression do it ? <https://sqlite.org/lang_with.html> WITH pattern in (pattern1,pattern2,pattern3) … UNION ALL … SELECT uuid FROM Data WHERE filter LIKE pattern Unfortunately I've not used them and don't know the right way to do it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
