title: codeigniter 3.0 like query add ESCAPE '!' on like
body: <p>codeigniter 3.0 like query add ESCAPE '!'</p>
  
  <p>example:</p>
  
  <pre><code> $this-&gt;db-&gt;select('*');
      $this-&gt;db-&gt;from('sample');
      $this-&gt;db-&gt;like('col','val%val2');
      $this-&gt;db-&gt;get()-&gt;result_array();
  </code></pre>
  
  <p>CI produces the query like following</p>
  
  <pre><code>SELECT * FROM `sample` WHERE `col` LIKE '%val!%val2%' ESCAPE '!'
  </code></pre>
  
  <p>But I expected it</p>
  
  <pre><code>SELECT * FROM `sample` WHERE `col` LIKE '%val%val2%' 
  </code></pre>
  
  <p>How can I achieve that?</p>