title: A simple SQL query doesn't work and I can't figure out what's wrong
body: <p>I'm really new to MySQL, trying to update a table row based on user name and row index, but it doesn't work. Tells me there's an error around 'INDEX = 54'. </p>
  
  <p>INDEX is the name of the auto-incrementing primary index column.</p>
  
  <pre><code>UPDATE `TABLENAME`
     SET NAME = 'NAME', DESCRIPTION = 'DESC'
   WHERE USER = 'name' AND INDEX = 54
  </code></pre>
  
  <p>Actually, even:</p>
  
  <pre><code>SELECT * FROM `tablename` WHERE INDEX=30
  </code></pre>
  
  <p>doesn't work; it says:</p>
  
  <blockquote>
    <p>"#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 'INDEX=30 LIMIT 0, 30' at line 1"</p>
  </blockquote>
  
  <p>I'm missing something basic here.</p>