SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table some_table(field1 text, field2 text)
insert into some_table(field1, field2) values
('a', 'b'), ('c', 'd'), ('a', 'e'), ('c', 's')
SELECT *
FROM some_table
WHERE (field1, field2) IN (('a', 'b'), ('c', 'd'))
row value misused

WITH cte(field1, field2) AS (VALUES ('a', 'b'), ('c', 'd'))
SELECT *
FROM some_table
WHERE (field1, field2) IN (SELECT field1, field2 FROM cte)


field1
field2


a
b

c
d


WITH cte(field1, field2) AS (VALUES ('a', 'b'), ('c', 'd'))
SELECT *
FROM some_table
WHERE (field1, field2) IN cte


field1
field2


a
b

c
d