SQLite tuples equality comparison

Question

With PostgreSQL and MySQL it is all right to do something like

SELECT * FROM mytable WHERE (column1, column2) = ('value1', 'value2');

When I tried the same thing on SQLite3, it gave me an exhausting error message:

Error: near ",": syntax error

From the SQLite documentation I can't figure out whether it supports tuples or not. Can anyone shed some light on this?

http://stackoverflow.com/questions/2596973/using-in-with-sets-of-tuples-in-sql-sqlite3 — Tim Sylvester, Apr 02 '11 at 00:54
Eh, sorry, must have overlooked that one, I only found several unrelated ones. Thanks for the link. — koniiiik, Apr 04 '11 at 08:37

score 2 · Answer 1 · answered Apr 02 '11 at 00:40

2

Do like this:

SELECT * FROM mytable WHERE column1 = 'value1' AND column2 = 'value2'

answered Apr 02 '11 at 00:40

Adi

This works for the case given but not where you want to fetch multiple rows like this using IN. To cover that you'd be stuck doing a monster `(x = ? AND y = ?) OR (x = ? AND y = ?) OR ....` – mikepurvis Sep 06 '20 at 16:56

score 2 · Accepted Answer · answered Apr 02 '11 at 00:56

2

The syntax is WHERE expr and as we can see in the syntax diagram for expr,
a column (expr) followed by a comma isn't supported.

expr: enter image description here

answered Apr 02 '11 at 00:56

Nick Dandoulakis

2 Answers2