Re: Intersecting multiple queries

Simon Slavin <[email protected]> Sat, 29 Feb 2020 00:57:14 +0000

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<[email protected]>

On 29 Feb 2020, at 12:45am, Keith Medcalf <[email protected]> wrote:

> select * from data where (...) AND (...) AND (...) <repeat until finished>;

SELECT uuid FROM Data
   WHERE filter LIKE ?
      OR filter LIKE ?
      OR filter LIKE ?
      OR filter LIKE ? …

would probably be an efficient way to do it if you could construct your entire statement.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users