Re: [sqlite] LIKE IN

2019-11-22 Thread David Raymond
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

Re: [sqlite] LIKE IN

2019-11-22 Thread Simon Davies
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'); >

[sqlite] LIKE IN

2019-11-22 Thread Hamish Allan
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');