title: selecting from a list in SQL and python
body: <p>I need help with the following scenario:</p>
  <p>in my database file I have a table who looks something like this</p>
  <p><img src="https://i.stack.imgur.com/dCMwJ.png" alt="https://i.stack.imgur.com/dCMwJ.png" /></p>
  <p>I want to get a list of all the IDs that have <code>suppliers_id=(2,3)</code> (list of ids)</p>
  <p>the problem is that I don't know which values are in the group (I'm getting the list in the function header from other SELECT function)</p>
  <p>We were taught that we can use IN option that should get me the result I want but I cant getting it to work</p>
  <p>my code (doesn't work for now):</p>
  <pre class="lang-py prettyprint-override"><code>    def update(self, suppliers_id):
          c = self._conn.cursor()
          c.execute(&quot;&quot;&quot;SELECT id FROM Vaccines WHERE supplier_id IN (?)&quot;&quot;&quot;, [suppliers_id])
  </code></pre>
  <p>I'm getting <code>sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type.</code> error</p>
  <p>Thanks!</p>