mysql field prefix, suffix, example of substitution operation

Add front, suffix concat, string replace replace

Add prefix

UPDATE ' table ' SET field_name = concat ("prefix", field_name);

Add suffix

UPDATE ' table ' SET field_name = concat (field_name, "suffix");

Bulk replacement

UPDATE ' table ' SET field_name = REPLACE (Intro, "Before_replace", "after_replace");

To make it clearer to you, let's look at a few examples

Add prefix

Update ' Ecs_goods ' Set Goods_name=concat (' New Chinese ', goods_name) where cat_id = 4;

Add suffix

Update ' Ecs_goods ' Set Goods_name=concat (Goods_name, ' new Chinese ') where cat_id = 4;

Delete

Update ' Ecs_goods ' Set Goods_name=right (Goods_name,length (goods_name)-1) where cat_id = 4;

Where Ecs_goods is the table name, cat_id is the category field name, Goods_name is the product field name