title: Oracle: merging two different queries into one, LIKE & IN
body: <p>I need to implement a search query, where we have multiple filters(values) for a single column in database(oracle). But these multiple filters(values) are <code>LIKE</code> query parameters. I am not sure that whether I am visioning correct result using the approach in mind.</p>
  
  <p>I want something that should work like:</p>
  
  <pre><code>departmentname IN ( LIKE '%Medi%', LIKE '%Ciga%')
  </code></pre>
  
  <p>I know it will not work, just I want to show the vision I am having.</p>
  
  <p>Though we all know that its simple using <code>foreach</code> and manually adding <code>'OR'</code> between queries like:</p>
  
  <pre><code>WHERE DEPARTMENTNAME LIKE '%Medi%' OR '%Ciga%' OR '%Tobacc%'
  </code></pre>
  
  <p>But is there any way to implement it using IN() AND LIKE simultaneously?</p>
  
  <p>Other suggestions are also welcomed.</p>