SQLite parameter substitution and quotes

by

To anyone who like me found this thread and got really frustrated by people ignoring the fact that sometimes you can’t just ignore the quotes (because you’re using say a LIKE command) you can fix this by doing something to the effect of:

var = name + "%"
c.execute('SELECT foo FROM bar WHERE name LIKE ?',(var,))

This will allow you to substitute in wildcards in this situation.

More Related Contents:

  1. Variable table name in sqlite
  2. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  3. No module named _sqlite3
  4. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  5. Django: Deploying an application on Heroku with sqlite3 as the database
  6. How do you escape strings for SQLite table/column names in Python?
  7. How to load existing db file to memory in Python sqlite3?
  8. Sqlite insert query not working with python?
  9. Python SQLite parameter substitution with wildcards in LIKE
  10. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  11. How can I get dict from sqlite query?
  12. Using a WHERE ___ IN ___ statement
  13. Python insert numpy array into sqlite3 database
  14. parameter unsupported when inserting int in sqlite
  15. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  16. Python SQLite: database is locked
  17. How to discover table properties from SQLAlchemy mapped object
  18. String similarity with Python + Sqlite (Levenshtein distance / edit distance)
  19. Auto Increment on Composite Primary Key – Sqlite3 + Python
  20. Is there a way to get a list of column names in sqlite?
  21. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  22. How to upgrade sqlite 3.8.2 to >= 3.8.3
  23. creating a database outside the application context
  24. How to open and convert sqlite database to pandas dataframe
  25. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  26. SQLite, python, unicode, and non-utf data
  27. Python and SQLite: insert into table
  28. Pycharm environment different than command line
  29. Can’t change system default SQLite binary
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment