Inserting a variable as column name in sqlite3 python

[JellyCreeper6]

So how exactly do you do it? I have tried doing this -

'UPDATE Table SET {} WHERE name=?'.format(col) , [name])

and this -

'UPDATE Table SET %s WHERE name=?' % (col,), [name]

Both have been giving me the error of

Error:
OperationalError: near "WHERE": syntax error

. Is this even possible?