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 ;