title: Search for any text with WHERE ... IN in Postgresql
body: <p>I would like to do an SQL query for a wildcard that returns all results.</p>
  
  <pre><code>SELECT *
  FROM my_table
  WHERE column1 IN ('*');
  </code></pre>
  
  <p>The idea would be to inject items by demand, like:</p>
  
  <pre><code>import psycopg2
  conn = psycopg2.connect(DSN)
  curs = conn.cursor()
  
  def my_func(filter='*'):
      curs.execute("""SELECT *
                      FROM my_table
                      WHERE column1 IN (%s);""" % filter)
      return curs.fetchall()
  
  my_func(filter=['value 1', 'value 2'])
  # or
  my_func()
  </code></pre>
  
  <p>The later (<code>*</code>) does not work in the <code>filter</code> keyword of <code>my_func</code>. Is there anything that would?</p>