DELIMITER $$ CREATE TRIGGER `user_email_check_update` BEFORE UPDATE ON `users` FOR EACH ROW BEGIN IF NEW.email not REGEXP '^([a-z0-9!#$%&\'*+/=?^_`{|}~-]++(?:\.[a-z0-9!#$%&\'*+/=?^_`{|}~-]++)*+@[a-z0-9](?:[a-z0-9-]*[a-z0-9])?+(?:\.[a-z0-9](?:[a-z0-9-]*[a-z0-9])?+)++)?$' THEN SIGNAL SQLSTATE '12345' SET MESSAGE_TEXT = 'Email validation Error!!!'; END IF; END$$ DELIMITER ;