$this->db->like

[eluser]arume[/eluser]
My solution:

Code:

$this->db->where('somefield LIKE '.$this->db->escape($fieldvalue), null, false);

By the way, maybe you must take care to not allow wildcards (in mysql "%" and "_"). Unfortunately CI don't care about that (in the AR LIKE method) nor provide a method to backslash it (as far as I know). So I wrote a function to do it in a mysql_helper.

Code:

function mysql_escape_like($str)
{
  return addcslashes($str, '%_');
}

So, the code will be:

Code:

$this->db->where('somefield LIKE '.mysql_escape_like($this->db->escape($fieldvalue)), null, false);