Filter python mysql result

Question

I am running a mysql query from python using mysql.connector library as per code below

cnx = mysql.connector.connect(host=mysql_localhost, user=user, password=password, database=database)
cursor = cnx.cursor()
cursor.execute("select  * from settings" )
results = cursor.fetchall()
ID, server, port, user, password, temp_min ,temp_max = results[0]
print(user)
cursor.close()
cnx.close()

the result is as follow

u'admin'

I noticed that values stored in the database as varchar display with u'' how can I get the value without the u'' so the desired output is

admin

alecxe · Accepted Answer · 2013-07-19 21:49:35Z

1

u means that this is a unicode string. You should read Unicode HOWTO for better understanding.

answered Jul 19, 2013 at 21:49

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Comments

jh314 · Accepted Answer · 2013-07-19 21:46:31Z

0

You can use str() to get rid of the u:

print str(user)

FYI-the u means it is unicode.

answered Jul 19, 2013 at 21:46

jh314

27.9k16 gold badges66 silver badges83 bronze badges

Comments

Robert Kajic · Accepted Answer · 2013-07-19 21:48:03Z

0

The u in front of your variable means that it is a unicode string. Is that really a problem? If you really need to convert it to a regular string you can use str(user).

answered Jul 19, 2013 at 21:48

Robert Kajic

9,1275 gold badges49 silver badges43 bronze badges

Collectives™ on Stack Overflow

Filter python mysql result

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related