How to add a number to the number that is in the table?

Question

There is a number in the table, you need to add to the number in the table, for example 2.

Pobezhimov Boris Pobezhimov Boris 1.548 four 20 · Accepted Answer · 2016-06-29T11:47:27

UPDATE `table_name` SET `field` = `field` + 2

and naturally the WHERE condition

Dan eStet Dan eStet 98 7 · Answer 2 · 2016-06-29T11:57:06

 UPDATE таблица SET столбец = `столбец` + 2 WHERE другой_стобец = строка

- this is SQL

 sql = "UPDATE таблица SET столбец = `столбец` + 2 WHERE другой_стобец"

- this is php

 $wpdb->query("UPDATE таблица SET столбец = `столбец` + 2 WHERE другой_стобец")

- this is wp

2 answers 2