Multiple WHERE clauses in sqlite3 python

Question

How do you add multiple WHERE clauses in an sqlite3 query, for example:

c.execute("SELECT * FROM requests WHERE driverID=? AND WHERE accepted='False'", (str(sid_login.get()),))

Although I get 'near "WHERE": syntax error' error.

unutbu · Accepted Answer · 2014-04-24 15:26:49Z

19

Just use one WHERE and combine conditions with AND:

c.execute("SELECT * FROM requests WHERE driverID=? AND accepted=?",
          (sid_login.get(), False))

Also, instead of manually quoting False, you could use parametrization and let sqlite3 do it for you.

answered Apr 24, 2014 at 15:26

unutbu

886k197 gold badges1.9k silver badges1.7k bronze badges

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

1 Answer 1