python cursor.execute(query, arg) : passing a list as an argument

Question

Basically I need to input a list in a query. It works very well with strings only but nut lists.

cursor.execute('select * from nicknames where name = %;', ('Smith', ))

So this one works, but then when I want to do the same with two names, then nothing.

cursor.execute('select * from nicknames where name in %s', ('(Smith, Andy)', ))

Do you know how I can make such a query ? Thanks

Martynas Markevičius · Accepted Answer · 2021-03-17 17:00:36Z

1

You can format it with the brackets inside the query like so:

cursor.execute('select * from nicknames where name in (%s, %s)', ("Smith", "Andy"))

answered Mar 17, 2021 at 17:00

1541 gold badge1 silver badge8 bronze badges

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

1 Answer 1