By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytablename(id int,column_2 int, field_1 int);
INSERT INTO mytablename VALUES (1,0,1)
UPDATE mytablename SET column_2 = IF(field_1 BETWEEN 1 AND 2, 12, field_1) WHERE id = 1
SELECT * FROM mytablename
| id | column_2 | field_1 |
|---|---|---|
| 1 | 12 | 1 |