Comparing string in mysql trigger

Question

Here is a trigger i created and i want to compare new.utype with employee as given below but dont know the actual way to compare it in mysql .. how can i achieve this and also please tell if condition syntax is correct or not

delimiter $$

CREATE TRIGGER insdetail_tomaster
AFTER INSERT ON tempdetail
FOR EACH ROW BEGIN
IF(new.utype =='employee') THEN
INSERT INTO master_employee values(new.field1,new.filed2);
ELSE 
INSERT INTO master_manager values(new.field1,new.fiel2);
END $$

DELIMITER ;

Answer 1

Use "like" key word as below

IF new.utype like 'employee' 

Entire trigger looks like this

delimiter $$

CREATE TRIGGER insdetail_tomaster
AFTER INSERT ON tempdetail
FOR EACH ROW BEGIN
IF new.utype like 'employee'  THEN
INSERT INTO master_employee values(new.field1,new.filed2);
ELSE 
INSERT INTO master_manager values(new.field1,new.fiel2);
END $$

DELIMITER ;

I assumed trigger you wrote other than the string comparison is correct Thanks