title: mysql, case sensitive compare through codeigniter
body: <p>I wanted to write following query through codeigniter's db helper class, guide me plz</p>
  
  <pre><code>SELECT * FROM table where column like binary "abc";
  </code></pre>
  
  <p>I tried</p>
  
  <pre><code>$this-&gt;db-&gt;select("*");
  $this-&gt;db-&gt;from("table");
  $this-&gt;db-&gt;like("column","binary abc");
  $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>but it produces</p>
  
  <pre><code>SELECT * FROM table WHERE column like '%binary abc%'
  </code></pre>