Hi all
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

Code:
UPDATE CYLINDER_ID '1'
VEHICLE_TYPE WHERE 
CYLINDERS 0>99