title: "ValueError: Unsupported format character ' " ' (0x22) at..." in Python / String
body: <p>I've seen a couple similar threads, but attempting to escape characters isn't working for me.</p>
  
  <p>In short, I have a list of strings, which I am iterating through, such that I am aiming to build a query that incorporates however many strings are in the list, into a 'Select, Like' query.</p>
  
  <p>Here is my code (Python)</p>
  
  <pre><code>def myfunc(self, cursor, var_list):
     query = "Select var FROM tble_tble WHERE"
     substring = []
     length = len(var_list)
     iter = length
  
     for var in var_list:
        if (iter != length):
           substring.append(" OR tble_tble.var LIKE %'%s'%" % var)
        else:
           substring.append(" tble_tble.var LIKE %'%s'%" % var)
        iter = iter - 1
  
     for str in substring:
        query = query + str
  ...
  </code></pre>
  
  <p>That should be enough. If it wasn't obvious from my previously stated claims, I am trying to <strong><em>build a query which runs the SQL 'LIKE'</em></strong> comparison across a <em>list</em> of relevant strings. </p>
  
  <p>Thanks for your time, and feel free to ask any questions for clarification.</p>