title: Can the "IN" operator use LIKE-wildcards (%) in Oracle?
body: <p>I have searched this question, and found an answer in MySQL but this is one of those incidents where the statement fails to cross over into Oracle.</p>
  
  <p><a href="https://stackoverflow.com/questions/1652318/">Can I use wildcards in &quot;IN&quot; MySQL statement?</a><br>
  pretty much sums up my question and what I would like to do, but in Oracle</p>
  
  <p>I would like to find the legal equivalent of</p>
  
  <pre><code>Select * from myTable m
  where m.status not in ('Done%', 'Finished except%', 'In Progress%')
  </code></pre>
  
  <p>Thanks for any help</p>