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
Hi,
On Fri, 22 Nov 2019 at 13:18, Hamish Allan wrote:
>
> Hi,
>
> Is it possible to achieve the effect of combining the LIKE and IN operators?
>
> So for instance if I have tables:
>
> CREATE TABLE names (name TEXT);
> INSERT INTO names VALUES ('Alexandra');
> INSERT INTO names VALUES ('Rob');
>
Hi,
Is it possible to achieve the effect of combining the LIKE and IN operators?
So for instance if I have tables:
CREATE TABLE names (name TEXT);
INSERT INTO names VALUES ('Alexandra');
INSERT INTO names VALUES ('Rob');
CREATE TABLE matches (match TEXT);
INSERT INTO matches VALUES ('Alex');
3 matches
Mail list logo