[eluser]jparent[/eluser]
Hi I try make a sentence like
select * from table where num_field = search_word OR text_field like %search_word%
if I do:
$this->db->or_where('num_field',$search_word);
$this->db->or_like('text_field',$search_word);
it makes a sentence like:
select * from table where num_field = search_word AND text_field like %search_word%
to solve it I use that:
$this->db->or_where("num_field = search_word OR text_field like %search_word%");
but that implies use SQL sintax and lossing de Abstraction.
Is there other way to construct this SQL with active record and no write SQL? Thanks!!