title: How to restrict a column value in SQLite / MySQL
body: <p>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.</p>
  
  <p>I also have the intention to add or remove more values in the future, for example, "truck".</p>
  
  <p>The type of Databases I am using are SQLite and MySQL.</p>