title: sqlite3 update database with "?" - python
body: <p>I have: </p>
  
  <p>database testing.db3
  table: mytable
  columns: 'name', 'status'</p>
  
  <p>I do:</p>
  
  <pre><code>con = sqlite3.connect('testing.db3')
  cur = con.cursor()
  cur.execute('select * from mytable where status is null')
  
  data = cur.fetchone()
  print(data[0])
  </code></pre>
  
  <p>as wanted I receive following result:</p>
  
  <pre><code>('Johnny', 'None')
  </code></pre>
  
  <p>Now I am trying to update this line, it works if I do:</p>
  
  <pre><code>cur.execute('UPDATE mytable SET status = "Online" WHERE name is "Johnny"')
  </code></pre>
  
  <p>However if I want to update it with '?', it just doesn't work. Any idea why?</p>
  
  <pre><code>cur.execute('UPDATE mytable SET status = "Online" WHERE name is ?', data[0])
  con.commit()
  con.close()
  </code></pre>
  
  <p>Would appreciate any help. Thank you.</p>