How to remove formatting from mysql query in python

Question

I'm working on a discord bot in python and so far I've got it to connect and fetch queries from the database and send it to the discord server. But the output is formatted still, how do I remove the brackets/commas.

Code:

@bot.command()
    async def mtop(ctx, arg1):  
    db = pymysql.connect(host=config.db_host, port=3306, user=config.db_user, passwd=config.db_passwd, db=config.db_name)
    cur = db.cursor()
    cur.execute("SELECT name FROM ck_playertimes WHERE mapname = %s AND runtimepro > -1.0 AND style = 0", (arg1,))
    name = cur.fetchone()
    await ctx.send(name)
    cur.close()
    db.close()

It outputs like this:

('Evan',)

Thank you.

Yang K · Accepted Answer · 2018-08-15 05:51:25Z

1

The brackets and commas indicate that "Evan" is inside of a tuple. So if your tuple will only have one element, then you can do ("Evan",)[0] in order to get the first element. If there are several elements in your tuple, then you will need to iterate through each one using a for loop. Like this:

for element in tup:
    # do something with element

answered Aug 15, 2018 at 5:51

Yang K

4454 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to remove formatting from mysql query in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related