How to build an UPDATE query correctly?

Question

MySQL

Good afternoon. I came across DML, and I can’t how to build a query like

UPDATE tovar SET count = view+1 WHERE view = 'view'

In our case, it comes out after WHERE when the condition must be met, and this is a change, but I want the view parameter to change for a specific product, but for all products.

Answer 1

Solved my question.