title: How to write an SQL statement to use "LIKE" for nine different values?
body: <p>I have to select all the records where:</p>
  
  <pre><code>where FIELD2 like '%value21%'
  or FIELD2 like '%value22%'
  or FIELD2 like '%value23%'
  -- repeat up to
  or FIELD2 like '%value29%'
  </code></pre>
  
  <p>Here, <code>value21</code>, ..., <code>value29</code> are parameters which the user can put in a form before submitting the query. They are (not subsequent) numerical codes, and <code>FIELD2</code> is a database column holding a string value.</p>
  
  <p>Which is the most compact form to write down my SQL query?</p>
  
  <p>Note: This is related to <a href="https://superuser.com/questions/199509/and-or-conditions-in-a-sql-query/">an earlier question</a>, but this needs <code>LIKE</code> rather than equals.</p>