title: How to match Underscore in String - MYSQL
body: <p>if column value is <code>2_apples</code> or <code>final_chapter</code> how do i match a value that contains an underscore <code>"_"</code> ? </p>
  
  <p>I've tried with: </p>
  
  <pre><code>SELECT DISTINCT brand FROM `items` WHERE brand like '%\\_'
  SELECT DISTINCT brand FROM `items` WHERE brand like '_'
  SELECT DISTINCT brand FROM `items` WHERE brand like '%_%'
  SELECT DISTINCT brand FROM `items` WHERE brand like LIKE '\_' 
  </code></pre>
  
  <p>It either shows all results or none. Any suggestions? </p>