title: Multiple SQL queries containing every element in a Python list in the LIKE operator
body: <p>I am trying to run multiple <code>SQL queries</code> where the <code>LIKE</code> operator contains every element of a list in <strong>Python</strong>.  I have a long list of strings</p>
  <pre><code>l = ['string1', 'string2', 'string3',....]
  
  query_1 = &quot;SELECT COUNT(request) FROM table WHERE request LIKE 'l[0]' AND DATE BETWEEN 'date1' AND 'date2'&quot;.format(l[0])
  query_2 = &quot;SELECT COUNT(request) FROM table WHERE request LIKE 'l[1]' AND DATE BETWEEN 'date1' AND 'date2'&quot;.format(l[1])
  query_3 = &quot;SELECT COUNT(request) FROM table WHERE request LIKE 'l[2]' AND DATE BETWEEN 'date1' AND 'date2'&quot;.format(l[1])
  </code></pre>
  <p>and so on.</p>
  <p>How would I run multiple queries and then concatenate them? Is it possible to use the <code>execute</code> function on multiple queries or can it only work with one? Would I use a for loop?</p>
  <p>EDIT: In the previous version of this question, I asked about running <strong>ONE</strong> query with multiple list elements in the <code>LIKE</code> operator. I realized that the final query was something along the lines of:</p>
  <pre><code>SELECT COUNT(request) FROM table WHERE request LIKE 'l[0]' OR LIKE 'l[1]' OR LIKE 'l[2]' AND DATE BETWEEN 'date1' AND 'date2'.
  </code></pre>
  <p>That was not what I needed.</p>