title: SQL for checking a set of values in 20 columns
body: <p>I have to check for a set of values in around 20 columns,</p>
  
  <pre><code>SELECT * FROM MY_TABLE WHERE
           COL1 IN ('01','02'..'10')
        OR COL2 IN ('01','02'..'10')  
        OR COL3 IN ('01','02'..'10')
        OR COL4 IN ('01','02'..'10')
        .
        .
        .
        .
        OR COL20 IN ('01','02'..'10')
  </code></pre>
  
  <p>Is there any alternate way which will be more effective?</p>