title: codeigniter FIND_IN_SET not working with join
body: <p>I have a <code>codeigniter-mysql</code> requirement to select values from <code>table_2</code> which joins <code>table_1</code> and need to apply where statement in a comma separated field value. Tried as follows,</p>
  
  <pre><code>$where  =  $this-&gt;db-&gt;escape("FIND_IN_SET(table_1.id,table_2.places_id)&lt;&gt;0");
  
      $this-&gt;db-&gt;select('table_2.*,GROUP_CONCAT(table_1.location)AS location');
      $this-&gt;db-&gt;from('table_2');
      $this-&gt;db-&gt;join('table_1', $where);
      $this-&gt;db-&gt;where('ltable_2.packages_id', $id);
      $results = $this-&gt;db-&gt;get();
      return $results-&gt;result();
  </code></pre>
  
  <p>But the above codeigniter db object returns following mysql query and its not working :(</p>
  
  <pre><code>SELECT `table_2`.*, GROUP_CONCAT(table_1.location)AS location FROM `table_2` JOIN `table_1` ON 'FIND_IN_SET(table_1.id,table_2.places_id)&lt;&gt;0' WHERE `ltable_2`.`packages_id` = &lt;id-goes-here&gt;
  </code></pre>
  
  <p>It seems the quotes around <code>'FIND_IN_SET(table_1.id,table_2.places_id)&lt;&gt;0'</code> creates the problem! All helps are appreciated to resolve the issue. </p>