title: Make an exception with a mySQL query
body: <p>I'm working on a CMS with CodeIgniter and I would like to make an exception with my SQL query</p>
  
  <pre><code>function get_categories()
  {
      $query = $this-&gt;db-&gt;get('ft_categories');
      return $query-&gt;result();
  }
  </code></pre>
  
  <p>This function will get every categories in my TABLE and I want to remove something from this result</p>
  
  <p>Example : </p>
  
  <p>I get this : <strong>CAT1 - CAT2 - CAT3 - SPECIALCAT</strong> from the query and I would like to remove the SPECIALCAT from the result by the name of this CAT</p>
  
  <p>Is it possible? How can I do that?</p>