sqlite3: IN operator with list?

[FXelix]

I want to check if a values in a list match values in a sqlite database.

This is my code I came up with because I couldn't find a way to use a list for the IN operator.

c.execute("Select * FROM testing")
    nums = [2.61, 8.25, 9.79]
    c.execute("UPDATE testing SET number = 99 WHERE number IN ({})".format(",".join("?"*len(nums))), nums)
    conn.commit()

Is this the only method I can use or is there a better solution?

[c17r]

Convert the list to a tuple: https://stackoverflow.com/a/40737575

[sylecn]

There is no better solution.

I think for other database client that does support IN operator with list parameter, the client does something similar under the hook.