> On Nov 9, 2017, at 12:50 PM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > > Is there any trick I can use that'll return AbcRfeDef and FedRfeAbc if > the two keywords are Abc and Def from a SQL call?
Use full-text search (FTS4 or FTS5). This is exactly what it’s for. Or as a hacky workaround, change the query to “… Title like ‘%Abc%’ and Title like ‘%Def%’”. —Jens _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users