How to update multiple values ​​in mysql base rows?

Question

PHP

There is a simple table in the database with three columns:
id, name, gorod

How to update the value of gorod, in rows with id from 50 to 100 for example?
The meaning of the task is that certain id ranges must be assigned a certain value gorod, for example - moskow
Can this be done with a regular SQL query?

Answer 1

UPDATE `table_name` SET `gorod`='moskow' WHERE `id`>50 AND `id`<100;