[sqlite] IN clause

estion) in ((2211, 'psuć się'), (2542, 'kontynuować'), (1449, 'wymrzeć')) Works: select * from card where (statNumber, question) in (select statNumber, question from card) Why? thanks and best regards Szyk Cech __

Re: [sqlite] IN clause

W dniu 18.01.2018 o 19:58, Richard Hipp pisze: Try it this way: SELECT * FROM card WHERE (statNumber,question) IN (VALUES(2211,'psuc sei'),(2542,'kontynuowac'), (1449,'wymrzec')); Thanks. This works (with spelling fixes). I am open to enhancing the syntax here, but not right now becau