How can I make a MySQL UPDATE command that increments by one the integer in a given field? Can this be done in one command?
Thanks
UPDATE table SET field=field+1 WHERE this=that;