title: How to INSERT a record using _date in WHERE clause?
body: <p>This is driving me insane. I'm trying to INSERT a value into the following "stats" table:</p>
  
  <pre><code>_date       spam1
  -----------------
  2011-06-13
  </code></pre>
  
  <p>using</p>
  
  <pre><code>INSERT INTO stats (spam1) VALUES (7) WHERE `_date` = '2011-06-13'
  </code></pre>
  
  <p>MySQL returns</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds 
  to your MySQL server version for the right syntax to use 
  near 'WHERE `_date` = '2011-06-13'' at line 1
  </code></pre>
  
  <p>I don't understand. Removing the quotes around the date or the backticks around _date doesn't help either. What am I doing wrong?</p>
  
  <p>[EDIT]
  Thanks - you all get an upvote :) How stupid of me...of course I need an UPDATE instead of INSERT...time to take a break I guess :P</p>