title: Using 'DATE_SUB(now(), INTERVAL 2 MONTH)' properly with Codeigniter
body: <p>I'm trying to run this query with Codeigniter:</p>
  
  <pre><code>SELECT * FROM `bf_bs_history` WHERE date &gt; DATE_SUB(now(), INTERVAL 2 MONTH) 
  </code></pre>
  
  <p>If I enter it directly in phpMyAdmin, I get the result I want. However, running if from the code, it will not take any effect. It's not filtering at all. 
  The PHP line looks like this:</p>
  
  <pre><code>$this-&gt;history_model-&gt;where(array('date &gt; ' =&gt; 'DATE_SUB(now(), INTERVAL 2 MONTH)'))-&gt;find_all();
  </code></pre>
  
  <p>Any idea where I go wrong?</p>