How to select multiple values with SQL

Question

I have a table in which cells can be as follows:

user_group can be admin, allow, disallow

user_subscription can be all, penalty, autogoal

I need to get the records that correspond to the following expression:

All admin and allow where user_subscription == all`` orautogoal```

I tried to do it like this:

('SELECT * FROM USERS WHERE (user_group="allow" OR user_group="admin" AND user_subscription="autogoal" OR user_subscription="all")')

But it does not work. I have 2 entries in the database:

user_group=admin, user_subscription=```all``
user_group=allow, user_subscription=```autogoal``

I always get only the second entry.

Tables don't have "cells", they have columns in rows. Thinking of a table as though it's a spreadsheet will cause nothing but pain. :) — Eric Brandt
– Eric Brandt, Commented Jul 18, 2019 at 16:22

forpas · Accepted Answer · 2019-07-18 16:18:05Z

1

You must use parentheses correctly, because the AND operator has higher precedence than the OR operator.
So your WHERE condition is equivalent to:

user_group="allow" 
OR 
(user_group="admin" AND user_subscription="autogoal") 
OR 
user_subscription="all"

Write the statement like this:

SELECT * FROM USERS 
WHERE 
  (user_group="allow" OR user_group="admin") 
  AND 
  (user_subscription="autogoal" OR user_subscription="all")

You can find more here.
Or with the IN operator:

SELECT * FROM USERS 
WHERE 
  user_group IN ("allow", "admin") 
  AND 
  user_subscription IN ("autogoal", "all")

edited Jul 18, 2019 at 16:18

answered Jul 18, 2019 at 16:10

forpas

165k10 gold badges51 silver badges85 bronze badges

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

2 Comments

kshnkvn Over a year ago

Ty, this work in DB Browser for SQLite but not work in python. Python give me anyway first one result. U dont know why this is?

forpas Over a year ago

It should work in Python also, if you write it correctly and you query the same table. Check again.

Mathieu Pagé · Accepted Answer · 2019-07-18 16:10:47Z

0

You are missing some parenthesis in your WHERE clause

Try this :

SELECT * 
  FROM USERS
 WHERE (user_group="allow" OR user_group="admin")
   AND (user_subscription="autogoal" OR user_subscription="all")

answered Jul 18, 2019 at 16:10

Mathieu Pagé

11.1k13 gold badges54 silver badges71 bronze badges

Collectives™ on Stack Overflow

How to select multiple values with SQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related