Create an "int" column forced between 0 and 3
thank you for your answers. I am using SQLite3 local on my laptop for testing purpose, I am not sure what the "real" database will be.
So for that reason and because it does not seem easy to restrict values in a certain range, I have solved my problem in the software itself.

Using the "AND" condition to check if values are in the interval I want: "UPDATE xxx SET xxx WHERE xx AND xx"

Thank you all.