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 <[email protected]>
wrote:
> Or alternatively something like:
>
> select * from table
> where exists (
> select query from queries
> where table.name like query
> );
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
