How to update multiple column values in MySQL table

Question

I want to update image path in MySQL table. Table schema is this:

table_brands - brand_id, brand_name, brand_image_path

Currently path is stored as-

`images/1.png`
`images/2.png`

I want to make it as

 `images/brands/1.png`
 `images/brands/2.png`

Also for some entries path is stored as

 `images/brands/1.png`
 `images/brands/2.png`

so changes should not be done for such entries.

Can someone help me?

geoandri · Accepted Answer · 2014-11-02 11:25:56Z

1

You can use replace function for this purpose only for the image paths that don't contain 'brand'

 UPDATE table_brand
 SET brand_image_path = REPLACE(brand_image_path, 'images', 'images/brands')
 WHERE brand_image_path NOT LIKE '%brands%';

answered Nov 2, 2014 at 11:25

geoandri

2,4282 gold badges18 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1