I think this will work:
INSERT INTO queries VALUES ('Alex');
INSERT INTO queries VALUES ('Rob');
select * from names
where exists (
select query from queries
where names.name like '%'||query||'%'
);
On Fri, 22 Nov 2019 at 15:19, David Raymond <david.raym...@tomtom.com>
wrote:
> Or alternatively something like:
>
> select * from table
> where exists (
> select query from queries
> where table.name like query
> );
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
