Increment by any constant number in a single SQL Update statement?
<p>Update a field by +1 (or any other integer increment) in table in sql, (PHP - Im using txt-db-api) in a single update statement. </p>

<p>Something like</p>

<pre><code>UPDATE tablename 
  SET current_value = current_value+1 
where condition=true
</code></pre>

<p>Although field is integer type but is not Auto_Increment type.</p>

<p><strong>Edit</strong></p>

<p>Actually I am not using MySQL but a flat text db called txt-db-api in PHP. I elaborate it as, increment a field value without knowing actual value or retrieving it (only knowing that it is an integer type) by any constant number or +1 (in my case).</p>

<p>CODE IS LIKE THIS:</p>

<pre><code>$ip_who=$_SERVER['REMOTE_ADDR'];

$query="UPDATE ratingtable SET rating_value='".valuealready+1."', rater_ip='$ip_who';
</code></pre>
