Python (PyMySQL) SELECT query returning boolean, not desired value

Question

I am using PyMySQL with Python to access my database. (MySQLdb is not yet available for newer releases of Python.)

This is my query:

cur = db.cursor()
cur.execute("SELECT ingredientID FROM Ingredients WHERE ingredientName = %s", "onions")

However, instead of returning the ingredientID, a boolean is returned stating the recipe was found. I have worked with MySQL(i) in PHP and have not had this issue occur in the past.

If by "boolean" you mean "byte literal" then this may help you: http://stackoverflow.com/questions/27855037/pymysql-connection-select-query-and-fetchall-return-tuple-that-has-byte-literals/27873654#27873654 — Michael D., Jan 10 '15 at 07:14

vaultah · Accepted Answer · 2014-03-31T17:06:11.653

3

You need to somehow fetch the result of the query:

cur = db.cursor()
cur.execute("SELECT ingredientID FROM Ingredients WHERE ingredientName = %s", "onions")
print(cur.fetchone()) # Fetch one row

or

print(cur.fetchall()) # Fetch all rows

edited Mar 31 '14 at 17:06

answered Mar 31 '14 at 17:01

vaultah

44,105
12
114
143

Thx! this works. My only question is how do I pull the value from the tuple that is created? – Yehuda Gutstein Mar 31 '14 at 17:06
[This answer](http://stackoverflow.com/questions/4940670/pymysql-fetchall-results-as-dictionary) explains how to do it – vaultah Mar 31 '14 at 17:11
Thanks again, right before you responded, I realized I could just use the fetchone() itself. – Yehuda Gutstein Mar 31 '14 at 17:12

Python (PyMySQL) SELECT query returning boolean, not desired value

1 Answers1

Linked