Need help creating a Trigger to replace a String

[Kung Wong]

Hello, I have the following problem:

I got a table called Article and a table called Image.

I need to write a Trigger, that inserts a replaced ArticleNumber into the Image table, as soon a new Article got inserted.

The logic for the replacement is

$renamedFilename = str_replace("-", "--", $renamedFilename);
$renamedFilename = str_replace("ß", "sz", $renamedFilename);
$renamedFilename = str_replace("Ü", "UE", $renamedFilename);
$renamedFilename = str_replace("Ö", "OE", $renamedFilename);
$renamedFilename = str_replace("Ä", "AE", $renamedFilename);
$renamedFilename = str_replace("ü", "ue", $renamedFilename);
$renamedFilename = str_replace("ö", "oe", $renamedFilename);
$renamedFilename = str_replace("ä", "ae", $renamedFilename);
$renamedFilename = str_replace("/", "__", $renamedFilename);
$renamedFilename = str_replace(".", "-", $renamedFilename);
$renamedFilename = str_replace(" ", "_", $renamedFilename);

But how do I add so many replaces into the trigger?

I thought of something like

DELIMITER $$

CREATE TRIGGER create_image_trigger
AFTER INSERT ON article
FOR EACH ROW
BEGIN
INSERT INTO image SET image = REPLACE(article_no, "-", "--")

END;
$$

DELIMITER ;

But that can't handle multiple replacements ...

Or do I need a function to handle that ?

with kind regards