mysql - uknown column in field list trigger -

what issue here? i'm using workbench. when try insert table staff error.

i'm trying insert table values ;staff' depending if on input 1 of columns.

error code: 1054. unknown column 'position' in 'field list' 0.046 sec       create trigger your_trigger_name     after insert on staff     each row  begin    if position = 'senior instructor'            insert new.senior_instructor         values (new.employee_name, new.date_of_birth);      end if; end; 

delimiter ||  create trigger your_trigger_name     after insert on staff     each row  begin    if new.position = 'senior instructor'            insert senior_instructor         values (new.employee_name, new.date_of_birth);      end if; end || delimiter ;