CHECK syntax

[Larry Irwin]

I'd like to set up my CREATE's to have CHECK and REGEXP but can't seem to
get 4.0.2 to accept my attempts...

CREATE TABLE IF NOT EXISTS aptype (
aptype_id          INT UNSIGNED NOT NULL AUTO_INCREMENT,
appt_type         VARCHAR(3) NOT NULL,
branch              VARCHAR(2),
print_ticket       VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP "[0-9]"),
print_on_stmt    VARCHAR(1), CHECK (print_on_stmt IN "Y|N|E|R"),
produce_ticket  VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
) TYPE=InnoDB;

None of the CHECK stmts will pass the syntax checker...
Help greatly appreciated.
Larry Irwin
CCA Medical
sql, query