CODEWITHSUNDEEP
pythonmysql
jdicarreira
jdicarreira

Reputation: 159

MySQL query returns data (u'example',)

I'm using a mysql lib on python, and when I try to do this query:

SELECT product FROM database1.contacts WHERE contact="%s" % (contact)

I get this:

(u'example',)

But I expect this:

example

Here is my code:

import mysql.connector

db_user = "root"
db_passwd = ""
db_host = "localhost"
db_name = "database1"

connector = mysql.connector.connect(user=db_user, password=db_passwd, host=db_host, database=db_name,
                                            buffered=True)
cursor = connector.cursor()
contact = "943832628"
get_product_sql = 'SELECT product FROM database1.contacts WHERE contact="%s"' % (contact)

cursor.execute(get_product_sql)

for product in cursor:
        print product

Upvotes: 4

Views: 1660

Answers (1)

Martijn Pieters
Martijn Pieters

Reputation: 1121724

You are printing the whole row; print just the first column:

for product in cursor:
    print product[0]

or use tuple unpacking in the loop:

for product, in cursor:
    print product

Upvotes: 5

Related Questions