title: full text search in codeigniter
body: <p>I have a query to search keywords using like, but I also want to search full text so I changed it to full text search query, but it doesn't work.</p>
  
  <p>The old query that's working fine:</p>
  
  <pre><code>$data = $this-&gt;db
      -&gt;select('content.title,content.id,content.category,content.body,path')
      -&gt;from('content')   
      -&gt;join('categories','content.category = categories.id')             
      -&gt;like('content.title', $searchterm)
      -&gt;like('content.body', $searchterm)
      -&gt;order_by("content.id","DESC")
      -&gt;get();
  </code></pre>
  
  <p>and this is my new query for full text search:</p>
  
  <pre><code>$data = $this-&gt;db
      -&gt;select('content.title,content.id,content.category,content.body,path')
      -&gt;from('content')   
      -&gt;join('categories','content.category = categories.id')                 
      -&gt;where('MATCH (content.body, content.title) AGAINST ("'. $searchterm .'")')
      -&gt;order_by("content.id","DESC")
      -&gt;get();
  </code></pre>