Executing “SELECT … WHERE … IN …” using MySQLdb

by

Unfortunately, you need to manually construct the query parameters, because as far as I know, there is no built-in bind method for binding a list to an IN clause, similar to Hibernate’s setParameterList(). However, you can accomplish the same with the following:

Python 3:

args=['A', 'C']
sql="SELECT fooid FROM foo WHERE bar IN (%s)" 
in_p=', '.join(list(map(lambda x: '%s', args)))
sql = sql % in_p
cursor.execute(sql, args)

Python 2:

args=['A', 'C']
sql="SELECT fooid FROM foo WHERE bar IN (%s)" 
in_p=', '.join(map(lambda x: '%s', args))
sql = sql % in_p
cursor.execute(sql, args)

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How do I get the “id” after INSERT into MySQL database with Python?
  7. Escape string Python for MySQL
  8. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  9. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  10. Cannot return results from stored procedure using Python cursor
  11. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  12. Inserting a Python datetime.datetime object into MySQL
  13. How to replace Django’s primary key with a different integer that is unique for that table
  14. MySQL — Joins Between Databases On Different Servers Using Python?
  15. How to retrieve SQL result column value using column name in Python?
  16. Using a Python dict for a SQL INSERT statement
  17. Bulk insert with SQLAlchemy ORM
  18. RuntimeError: working outside of application context
  19. Python Pandas write to sql with NaN values
  20. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  21. ImportError: No module named MySQLdb
  22. Can’t install mysql-python (newer versions) in Windows
  23. Using Django database layer outside of Django?
  24. How to move a model between two Django apps (Django 1.7)
  25. How do i cast char to integer while querying in django ORM?
  26. flake8 complains on boolean comparison “==” in filter clause
  27. How do I get time from a datetime.timedelta object?
  28. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  29. Installing mysql-python on Centos
  30. Context manager for Python’s MySQLdb

Leave a Comment