Obviously that would happen during the creation of the table.

```
CREATE TABLE Employees(
    e_id INT NOT NULL AUTO_INCREMENT,
    e_name VARCHAR(20) NOT NULL,
    type CHAR(3) NOT NULL,
    CONSTRAINT type CHECK (type IN ('FOH, 'BOH', 'TCH', 'SHF', 'KSH', 'MOM', 'SIS')),
    PRIMARY KEY (e_id)
);

```

mysql doesn't let this work and I'm not sure how to do it. Basically, type is supposed to be a word only from one of the seven words ('FOH', 'BOH', ... etc).

Does anyone know how to solve this?