Python MySQL query output

Question

I am trying to query a MySQL table to get a specific user type depending on their email

import pymysql

conn= pymysql.connect(host='<ip>',user='<user>',password=<pass>',db='<db>')

a = conn.cursor()

a.execute("SELECT `type` FROM `users` WHERE `email` LIKE '<email>';")

data = a.fetchone()

print(data)

The output is ('user',), how can I get the output to be just user

Dan · Accepted Answer · 2018-05-11 18:39:39Z

1

It returned a tuple. So check if it has correct number of elements (1) and extract element desired:

if len(data) == 1:
    print data[0]

answered May 11, 2018 at 18:39

Dan

4,7236 gold badges53 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python MySQL query output

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related