active record doubt

[eluser]Aken[/eluser]
After a little research, you should be able to use a LIKE command with no wild cards just as you would a "WHERE = something" command. However, there's no option to use the $this->db->like() function without any wildcard placement.

You can, however, use a very minor custom query string inside an or_where() function:

Code:

$search = 'search_word';

$this->db->where('num_field', $search);
$this->db->or_where('text_field LIKE', "%$search%");
$query = $this->db->get('table');