Codeigniter like, or_like doesn't work with where
<p>I found a problem in my codeigniter app. I've written a simple search query using 4 different like and or_like. </p>

<pre><code>$q = $this-&gt;db-&gt;select('*')
-&gt;from('table')
-&gt;like('col', $search_string1, both)
-&gt;or_like('col', $search_string2, both)
-&gt;or_like('col', $search_string3,  both)
-&gt;or_like('col', $search_string4, both)
-&gt;get()-&gt;results
</code></pre>

<p>And it works as I wanted, but I decided to add new col in my table called "active" and I want to display only rows that got active = 1. So I tried to add where to my query, but it didn't worked as I expected. </p>

<pre><code>$q = $this-&gt;db-&gt;select('*')
-&gt;from('table')
-&gt;where('active', 1)
-&gt;like('col', $search_string1, both)
-&gt;or_like('col', $search_string2, both)
-&gt;or_like('col', $search_string3,  both)
-&gt;or_like('col', $search_string4, both)
-&gt;get()-&gt;results
</code></pre>

<p>This query show also rows that got active set as 0. How can I fix that to display only rows with active = 1 in codeigniter? </p>