title: How to use Find_IN_SET in codeigniter?
body: <pre><code>public function job_fetch($key)
      {
          $this-&gt;db-&gt;select('*');
          $this-&gt;db-&gt;from('job');
          $where = "FIND_IN_SET(".$key.", job_title) and FIND_IN_SET(".$key.", city)";
          $this-&gt;db-&gt;where($where);
          $query = $this-&gt;db-&gt;get();
          $result = $query-&gt;result_array();
          return $result;
      }
  </code></pre>
  
  <p>In this code, I am passing a variable i.e. <code>$key</code> where <code>$key</code>is an array and it look like <code>Array ( [0] =&gt; java [1] =&gt; developer [2] =&gt; hibernate [3] =&gt; struts [4] =&gt; in [5] =&gt; mumbai [6] =&gt; noida [7] =&gt; delhi</code> and I want to fetch data by <code>job_title</code> and <code>city</code> if value lies in <code>$key</code> so how can I fix it? Please help me.</p>
  
  <p>Thank You</p>