Re: Intersecting multiple queries

On 28 Feb 2020, at 11:02pm, Hamish Allan <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users