Here in the mysql bug report #25660, one of the author says that MySQL CHECK constraint does not work. And it has been 3 years during 2009.
Now, it is een mid of 2011. Yet no movement.
MySQL CHECK constraint still does not work.
Can you suggest other ways of doing the similar constraints checks? Triggers? How?
use a foreign key to a table which lists the valid values