title: Oracle select from a table where value contains an underscore
body: <p>I have a query where i need to select from a table where value starts with M_. Problem is that the underscore is a wildcard character in oracle. So take following data in the description field:</p>
  
  <pre><code>M1
  M_1
  M2
  M_2
  </code></pre>
  
  <p>When i run following query all fields are returned:</p>
  
  <pre><code>select description from table where description like 'M_%'
  </code></pre>
  
  <p>I tried escaping with following query which returns no results:</p>
  
  <pre><code>select description from table where description like 'M\_%'
  </code></pre>
  
  <p>The results i am looking for are only descriptions that start with M_ so expected results are:</p>
  
  <pre><code>M_1
  M_2
  </code></pre>
  
  <p>Thanks in advance for any help</p>