Magento 2: Update Query Using Standard Way

Question

I have UPDATE posts SET viewed = viewed + 1 WHERE id = 1 MySql Query

I have referred https://webkul.com/blog/magento2-write-custom-mysql-query-without-using-model/ But i want to as we do Select Way, Means Standard Way

Example:

$select = $this->getConnection()
                ->select()
                ->from(['posts' => $this->getMainTable()])
                ->where(
                'posts.id = ?', $id);

Answer 1

Try using:

$this->getConnection()->update(
    'posts',
    [
        'viewed' => new \Zend_Db_Expr('viewed + 1'),
    ],
    ["id = ?" => 1]
);