check constraint

[Denis Gefke]

Hi all. Sorry for my English.
Please, tell me, can i use CHECK constraint in create table statement? I create table with check. There are no erros. But then i try to add new row with incorrect value, this constraint does not work :(.

CREATE TABLE IF NOT EXISTS gvars
id int unsigned NOT NULL PRIMARY KEY,
name varchar(256) NOT NULL UNIQUE,
value int NOT NULL default 0,
min_value int NOT NULL default -1000,
max_value int NOT NULL default 1000,
descript varchar(2048),
CHECK (name LIKE 'g%');