title: MYSQL UPDATE - 1 DAY off DATE field?
body: <p>I have a table which stores featured from and to for objects. I would like to unfeature an item via ajax.</p>
  
  <p>The way I have decided todo that is to set any featured rows for an object called to -1 day from now so its no longer featured.</p>
  
  <p>However my query isn't working.</p>
  
  <pre><code>UPDATE `Movie_Featured` SET `to` = DATE_SUB(CURDATE(), INTERVAL 1 DAY) WHERE id &gt; 0 $where
  </code></pre>
  
  <p>Ideas? Thanks!</p>