I am trying to save some manual time by search and replacing in my PostgreSQL database.
I have a table called Products_Colors
where i'd like to replace all text in column color_image
where column color_id
is equal to 21.
UPDATE
Product_Colors
SET
color_image = REPLACE(color_image,"cars/car_2018.webp","cars/car_2019.webp")
WHERE
color_id = 21
Would this be correct syntax?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…