如何在SQLite / MySQL中限制列值

I would like to restrict a column value in a SQL table. For example the column values can only be "car" or "bike" or "van". My question is how do you achieve this in SQL, and is it a good idea to do this on the DB side or should i let the application restrict the input.I would like to restrict a column value in a SQ