Why do I get “TypeError: not all arguments converted during string formatting” when trying to use a string in a parameterized SQL query?

by

Instead of this:

cur.execute( "SELECT * FROM records WHERE email LIKE '%s'", search )

Try this:

cur.execute( "SELECT * FROM records WHERE email LIKE %s", [search] )

See the MySQLdb documentation. The reasoning is that execute‘s second parameter represents a list of the objects to be converted, because you could have an arbitrary number of objects in a parameterized query. In this case, you have only one, but it still needs to be an iterable (a tuple instead of a list would also be fine).

More Related Contents:

  1. Python def function return None in all cases
  2. Convert pandas dataframe to NumPy array
  3. In Matplotlib, what does the argument mean in fig.add_subplot(111)?
  4. Does python urllib2 automatically uncompress gzip data fetched from webpage?
  5. How to enumerate an object’s properties in Python? [duplicate]
  6. Schedule Python Script – Windows 7
  7. Update a dataframe in pandas while iterating row by row
  8. Securely storing environment variables in GAE with app.yaml
  9. Crontab not executing a Python script? [duplicate]
  10. Reuse part of a Regex pattern
  11. Creating a class within a function and access a function defined in the containing function’s scope
  12. Python subprocess and user interaction
  13. Meaning of end=” in the statement print(“\t”,end=”)? [duplicate]
  14. Is there a way to find an element by attributes in Python Selenium?
  15. How to redirect with messages to display them in Django Templates?
  16. WARNING: Running pip as the ‘root’ user
  17. How does using the try statement avoid a race condition?
  18. How do you verify an RSA SHA1 signature in Python?
  19. How to get autocomplete in jupyter notebook without using tab?
  20. Python modbus library [closed]
  21. Reverse a string without using reversed() or [::-1]?
  22. python-win32com excel com model started generating errors
  23. pickle – putting more than 1 object in a file? [duplicate]
  24. Compute a confidence interval from sample data assuming unknown distribution
  25. Make the Python json encoder support Python’s new dataclasses
  26. Eliminating warnings from scikit-learn [duplicate]
  27. Adapt an iterator to behave like a file-like object in Python
  28. django excel xlwt
  29. How do I get around HttpError 403 Insufficient Permission? (gmail api, python)
  30. X-axis tick labels are too dense when drawing plots

Leave a Comment