PostgreSQL Select where multiple OR statements

Question

I have the following PgSQL query, in which i'm looking where user_id equals any one of a set of id's i am looking for.

Question is, is there a way to simply the statement so that I dont have to keep putting user_id= ?

SELECT * 
FROM comments 
WHERE session_id=1 
AND (user_id=10 OR user_id=11 
     OR user_id=12 OR user_id=13 
     OR user_id=14 OR user_id=15 
     OR user_id=16)

user330315 · Accepted Answer · 2014-01-17 09:26:36Z

26

SELECT * 
FROM comments 
WHERE session_id=1 
  AND user_id in (10,11,12,13,14,15,16);

alternatively for this specific case:

SELECT * 
FROM comments 
WHERE session_id=1 
  AND user_id between 10 and 16;

answered Jan 17, 2014 at 9:26

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL Select where multiple OR statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related