title: How to use like, or_like and get_where together in Codeigniter 3
body: <p>I'm trying to search with a keyword but only in the rows where business_type is manufacturer but it's not working and it's getting all the rows. This is the method in my model:</p>
  
  <pre><code>public function search($keyword) {
      $this-&gt;db-&gt;like('category',$keyword);
      $this-&gt;db-&gt;or_like('keyword',$keyword);
      $this-&gt;db-&gt;or_like('products_deals_with',$keyword);
      $this-&gt;db-&gt;or_like('buisness_name',$keyword);
      $params['conditions'] = array(
          'business_type' =&gt; 'manufacturer'
      );
      $query = $this-&gt;db-&gt;get_where('business_listings', $params['conditions']);
      return $query-&gt;result_array();
  }
  </code></pre>
  
  <p>Generated query is:</p>
  
  <pre><code>SELECT * FROM `business_listings`
  WHERE `category` LIKE '%%' ESCAPE '!'
  OR `keyword` LIKE '%%' ESCAPE '!'
  OR `products_deals_with`LIKE '%%' ESCAPE '!'
  OR `buisness_name` LIKE '%%' ESCAPE '!'
  AND `business_type` = 'manufacturer'
  </code></pre>