title: With python sqlite3 module, how to deal with fields that contain double-quotes?
body: <p>I was trying to access a database that has data that contains "" such as:</p>
  
  <blockquote>
    <p>Tom "is" a cat.</p>
  </blockquote>
  
  <p>When I use this code:</p>
  
  <blockquote>
    <p>myData = 100; myKey = 'Tom "is" a cat.' </p>
    
    <p>myCursor.execute('UPDATE MyTable SET MyField = %d WHERE MyTable.Key ==
    "%s"' % (myData, myKey))</p>
  </blockquote>
  
  <p>I got this error</p>
  
  <blockquote>
    <p>sqlite3.OperationalError: near "is": syntax error</p>
  </blockquote>
  
  <p>Note that I've enclosed my %s with "".
  I've also tried to use single-quotes around it or adding \, neither worked.
  Any idea how to solve this?</p>