delimiter |
CREATE TRIGGER remove_firstchar BEFORE INSERT ON customer
FOR EACH ROW
BEGIN
IF NEW.phone LIKE '%+%' THEN
SET new.phone = replace(new.phone, '+', '');
END IF;
END
|
delimiter ;