title: DataTables: filter rows based on value in column
body: <p>I need to filter out rows from a datatable that do not contain a certain value in a column. For example, with the data below, I would like to just show results where type = "Dog":</p>
  
  <pre><code>&lt;table id="petowners"&gt;
  &lt;tr&gt;
      &lt;th&gt;Type&lt;/th&gt;
      &lt;th&gt;Breed&lt;/th&gt;
      &lt;th&gt;Owner&lt;/th&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Dog&lt;/td&gt;
      &lt;td&gt;Doberman&lt;/td&gt;
      &lt;td&gt;Peter&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Cat&lt;/td&gt;
      &lt;td&gt;Jaguar&lt;/td&gt;
      &lt;td&gt;Paul&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Dog&lt;/td&gt;
      &lt;td&gt;Poodle&lt;/td&gt;
      &lt;td&gt;Mary&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Cat&lt;/td&gt;
      &lt;td&gt;Lion&lt;/td&gt;
      &lt;td&gt;Ringo&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Cat&lt;/td&gt;
      &lt;td&gt;Tiger&lt;/td&gt;
      &lt;td&gt;John&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>Here's the script that I am using to configuring sorting and results-per-page. Obviously the column-based filtering is the missing bit I need help with.</p>
  
  <pre><code>$(document).ready(function() {
      $('#petowners').dataTable( {
          "order": [[ 0, "asc" ]],
          "iDisplayLength": -1,
          "oLanguage": 
              {
                  "sLengthMenu": 'Display &lt;select&gt;'+
                      '&lt;option value="10"&gt;10&lt;/option&gt;'+
                      '&lt;option value="10"&gt;25&lt;/option&gt;'+
                      '&lt;option value="10"&gt;50&lt;/option&gt;'+
                      '&lt;option value="100"&gt;100&lt;/option&gt;'+
                      '&lt;option value="500"&gt;500&lt;/option&gt;'+
                      '&lt;option value="-1"&gt;All&lt;/option&gt;'+
                      '&lt;/select&gt; records'
              },
      } );
  } );
  </code></pre>
  
  <p>I need to add two links, buttons or checkboxes, one for "Dog" and one for "Cat".</p>
  
  <p>When a user clicks "Dog", only the rows that contain "Dog" in the "Type" column are displayed. Similarly when "Cat" is clicked, only the rows that containt "Cat" in the "Type" column should be displayed.</p>
  
  <p>It seems like a fairly straightforward feature, but I have not been able to find anything in the datatables.net site that shows how this could be done.</p>
  
  <p>I hope this makes sense and someone can help.</p>
  
  <p>Many thanks in advance
  wOnkO tHe SaNE</p>