title: How to use LIKE statement in sql plus with multiple wild carded values?
body: <p>my question is that currently if i want to query for multiple wildcarded values. I need to do something like this.</p>
  
  <pre><code>select customername from customers where customername like '%smith' or customername like '%potter' or customer name like '%harris' or customername like '%williams';
  </code></pre>
  
  <p>So I wanna ask from the experts, is there any easier way to do this?</p>
  
  <p>Regards,
  Sanjan</p>