title: php/mysql : Is it possible to add one to the field without selecting from db?
body: <p>I have this code...</p>
  
  <pre><code>$q = "SELECT count FROM " . TABLE_PREFIX . "count WHERE 1 LIMIT 1;";
          $r = mysql_query($q);
  
          if (!$r) {
              echo $q;
              return false;
          }
  
          $o = mysql_fetch_object($r);
          $count = $o-&gt;count + 1;
  
      $q = "UPDATE " . TABLE_PREFIX . "count SET `count` = {$count}";
  </code></pre>
  
  <p>As you can see it selects field from db(its just a number) and adds 1 to it before sending it back to db...</p>
  
  <p>Is it possible to skip the selecting part and instead just say something like:</p>
  
  <pre><code>`SET `count` += 1`
  </code></pre>
  
  <p>or something like that?</p>