MySql problem

Hi /prog/,

A MySQL noob needs some help here. I tried searching everywhere but it seems I cannot formulate my search expression correctly(English is not my first language). So the problem is. I want to limit the values that can be inserted in a column to certain possibilities. For example: I have a column phone_type and I want the only possible values there to be Work, Mobile, General and Fax. Any ideas? Sorry if this is too simple!

>>15
MySQL recognizes the keyword, but doesn't enforce the constraints unless you're using the InnoDB backend, and the default is MyISAM which is just incompetent and useless. So technically it supports them, but in practicality it really doesn't.

>>15
Well, it depends on your point of view.
MyISAM, which is the default engine MySQL uses, supports none of these things and never will. InnoDB supports a few features MyISAM doesn't (including foreign keys, I thought), but is a buggy, unstable piece of shit that's even more likely to fuck up your data than MyISAM; its only purpose is to serve as something MySQL fanboys can point to when sensible people point out MySQL is a joke of a RDBMS.