CODE EXAMPLE FOR SQL

between in sql

UPDATE columnName SET fieldName = 100 WHERE prod_id BETWEEN 10 AND 20;