title: python sqlite3: How to use LIKE and ? to do partial matching?
body: <p>With python sqlite3, I'd like to something like</p>
  
  <pre><code>cursor.execute('SELECT * FROM songs WHERE filename LIKE "?%"', (key_string,))
  </code></pre>
  
  <p>so that I can use the key as a variable instead of having to hard code the pattern.
  But this does not work and gives me:</p>
  
  <pre><code>ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.
  </code></pre>
  
  <p>Please help.</p>