title: MySQL Active record query ignoring case
body: <p>I have the following active record query:</p>
  
  <pre><code>$this-&gt;db-&gt;select('id, firstname, surname');
  $this-&gt;db-&gt;from('users');
  $this-&gt;db-&gt;where('site_id',$siteid);
  $this-&gt;db-&gt;like('firstname', $name);
  $this-&gt;db-&gt;or_like('surname', $name); 
  $query = $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>This works fine with the exception that my names within the DB can contain upper and lowercase names. If the case does not match, the query fails.</p>
  
  <p>Is there any way I can ignore the case with my query?</p>