How can i resolve 'operand should contain 1 column(s)' in sql?


SELECT * FROM users WHERE (id, name) = (1);

This error indicates that the left-hand side has multiple columns, while the right-hand side has a single value.


Ensure that both sides of the operand have the same number of columns.

SELECT * FROM users WHERE id = 1;

Beginner's Guide to SQL