Increment field value in update query I am converting some module from d5 to d7, and in old code there is an update query like this:

&lt;?php
db_query("UPDATE {a_table} SET count = count + 1 WHERE field1 = %d", $some_value);


As we see, it is incrementing a field value (AFAIK it is a mysql feature).
But, if I use new style of update it won't work.

&lt;?php
db_update('a_table')
    -&gt;fields(array('count' =&gt; 'count + 1',))
    -&gt;condition('field1', $some_value)
    -&gt;execute();


Are there any workaround within new style of db update without running an extra query to get existing field value to increment it?
You can do it by adding an expression to the query:

db_update('a_table')
  -&gt;expression('count', 'count + 1')
  -&gt;condition('field1', $some_value)
  -&gt;execute();