Mysql trigger to auto generate 18 digit Id String on before insert table record

CREATE TRIGGER `AutoGenerateIdOnTestTaker` BEFORE INSERT ON `TestTaker`
 FOR EACH ROW SET New.Id = (SELECT SUBSTRING(MD5(RAND()) FROM 1 FOR 18))