Help with a trigger

[Robert Wiglesworth]

I am trying to create a trigger that will look at the value of a particular field in a new record, compare it to a variable, and if it matches set another field.

I have tried something like this for a befor insert:

begin
declare chkcode char;
set @chkcode := 'whateverisetthisto';

if new.code = @chkcode
then new.passed = 1;
end if;
end;

That resulted in the record not being inserted. I changed it to an after insert with this code:

begin
declare chkcode char;
set @chkcode := 'whateverisetthisto';

if code = @chkcode
then update events set passed = 1;
end if;
end;

That would allow the record to insert, but it did not update the field as I wanted.

Can someone give me a hand figuring this out?

Thanks