Re: Trigger to replace string

[Devart Team]

The syntax can be like this -

DELIMITER $$

CREATE TRIGGER cp
BEFORE UPDATE
ON clientsshared
FOR EACH ROW
BEGIN
  SET @tech_prefix = NEW.tech_prefix;
  IF @tech_prefix LIKE '%CP:000%' THEN
    SET @pos = LOCATE('CP:', @tech_prefix) + 3;
    SET @len = LOCATE(';', @tech_prefix, @pos) - @pos;
    SET NEW.tech_prefix = INSERT(@tech_prefix, @pos, @len, '48222111444');
  END IF;
END
$$

DELIMITER ;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/