title: Python+sqlite: the LIKE query with wildcards
body: <p>Hi
  I'm trying to search an SQlite table based on a user input with wildcards. I've tried different methods by I can't get it to work.
  This is the last thing I tried, it's a solution I found here actually, but it might have changed in python 3.</p>
  
  <pre><code>    search = input("type name or partial name: ")
      cur.execute("select * from contacts where name like ?",
                  ('%'+search+'%'))
  </code></pre>
  
  <p>This produces this error on that last line there.</p>
  
  <pre><code>sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 5 supplied.
  </code></pre>
  
  <p>I tried a lot of different thing and this is driving me crazy. I'm starting to think this isn't possible without reading the entire table to a string first.</p>