I have a mysql table called vehicle_type and it has a column called cylinder_id
The value in cylinder_id is a number that is defined by the value in the column cylinders.
I want to update all the values in cylinder_id to 1 where the value in cylinders is between 0-99
This is my attempt- what am I doing wrong? Thank you
UPDATE CYLINDER_ID '1'