title: sql like clause with many values
body: <p>I have 4 columns in my table. Now since this is more of a data cleanup task I am not really that particular about the performance. But still I would like to know the possible options.</p>
  
  <p>Look at the query below:</p>
  
  <pre><code>SELECT * FROM dsopi_person_addr_rule ADDR WHERE 
  addr.src_address_line1 LIKE '%DEP%' 
  OR addr.src_address_line2 LIKE '%DEP%'
  OR addr.src_address_line3 LIKE '%DEP%'
  OR addr.src_address_line4 LIKE '%DEP%';
  </code></pre>
  
  <p>Similar to DEP I have 10 more matches. I need to repeat each match for all the 4 address lines. Is there a better way to do it? I personally hate writing again and again.</p>
  
  <p>**Updated: Below is the answer</p>
  
  <pre><code>SELECT *
  FROM dsopi_person_addr_rule ADDR
  WHERE regexp_like (UPPER(addr.src_address_line1),      'DEP|DPT$|ABT|DIP.|DIPART|AFDEL|AVDEL|AVD.|DIV|PGRD|PGP|PPG')
  </code></pre>