The right place to store allowable values for a field is in a separate lookup table, with a foreign key constraint that forces the value to be one of the keys from the lookup table. MySQL supports this just fine as long as you use InnoDB tables.