title: Trying to add 1 to current field value with MySQL, but can't figure out what's wrong with my syntax
body: <p>I'm hoping someone can spot my mistake in this MySQL query.</p>
  
  <pre><code>UPDATE 'databasename'.'tablename' 
     SET fieldB = fieldB + 1 
   WHERE fieldA = '2';
  </code></pre>
  
  <p>I'm basically trying to add 1 to the current value of fieldB where fieldA is i.e 2.</p>