How to update sqlite table where values on list using python?

Question

I want to update table on sqlite contained with many rows

tablenew  
id  status
a   old
b   ask
c   old
d   old

etc...

list = ['a', 'b', 'c']

cur.execute("update tablenew set status =? where id = ?", ('new',list))

how to do this in python?

ThiefMaster · Accepted Answer · 2012-05-11 06:14:42Z

4

Use the IN operator:

cur.execute("update tablenew set status = ? where id IN ?", ('new', list))

answered May 11, 2012 at 6:14

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

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

1 Answer 1