MySql trigger to replace text

everybody! I have a trigger to replace text BEFORE INSERT to table, i have a text in which need change one word SET NEW.shipping_method = CASE WHEN NEW.shipping_method LIKE ‘weight’ THEN ‘Svars’ ELSE …