Using a WHERE ___ IN ___ statement

by

You need to create enough parameters to match your list of vars:

statement = "SELECT * FROM tab WHERE obj IN ({0})".format(', '.join(['?'] * len(list_of_vars)))
c.execute(statement, list_of_vars)

Note that you pass in list_of_vars as the parameter values list. Using the ', '.join() we generate a string of ? characters separated by commas, then use .format() to insert that into the statement.

For a long list of variables, it may be more efficient to use a temporary table to hold those values, then use a JOIN against the temporary table rather than an IN clause with bind parameters.

More Related Contents:

  1. How can I get dict from sqlite query?
  2. How to get a single result from a SQL query in python?
  3. Is this Python code vulnerable to SQL injection? (SQLite3)
  4. pysqlite: Placeholder substitution for column or table names?
  5. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  6. Python SQLite3 SQL Injection Vulnerable Code
  7. Python and SQLite: insert into table
  8. How to check the existence of a row in SQLite with Python?
  9. Pandas read_sql with parameters
  10. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  11. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  12. How to create a large pandas dataframe from an sql query without running out of memory?
  13. Passing table name as a parameter in psycopg2
  14. Getting the SQL from a Django QuerySet [duplicate]
  15. Python SQLite parameter substitution with wildcards in LIKE
  16. parameter unsupported when inserting int in sqlite
  17. pyodbc – How to perform a select statement using a variable for a parameter
  18. LEFT JOIN Django ORM
  19. Python sqlite3 string variable in execute
  20. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  21. Python, SQLAlchemy pass parameters in connection.execute
  22. SQLite parameter substitution and quotes
  23. String similarity with Python + Sqlite (Levenshtein distance / edit distance)
  24. How to log all sql queries in Django?
  25. Is there a way to get a list of column names in sqlite?
  26. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  27. Dynamic SQL Queries with Python and mySQL
  28. How to upgrade sqlite 3.8.2 to >= 3.8.3
  29. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  30. How to delete a record in Django models?

Leave a Comment