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

Example:

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.

Solution:

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


SELECT * FROM users WHERE id = 1;

Beginner's Guide to SQL