Dynamically change values for SQL Server table?

Question

I have a SQL Server table with the following column names:

ItemID
Title
Description
ImagePath

filled with about 300 items. Now, the ImagePath column name is filled with different images for each entry, but they all have the same root folder in common (e.g. /project/images/1.jpg, /project/images/2.jpg, /project/images/3.jpg, etc.). I have been asked to move the images somewhere else, however, so now the root folder has changed (suppose the new location is /projects/project-a/images), and I'd like to know if there's a way of updating the ImagePath at once for all entries, as opposed to having to go through every single one of them manually. If possible, I'd like to avoid dropping and creating the table again.

Am I missing something; what's wrong with a simple update script? — Peter Smith
– Peter Smith, Commented Jan 17, 2016 at 10:20

Zohar Peled · Accepted Answer · 2016-01-17 10:21:01Z

4

If the data type of the ImagePath column is char, varchar, nchar, or nvarchar, but NOT text or ntext, you can simply use the built in REPLACE method:

UPDATE tableName
SET ImagePath = REPLACE(ImagePath, '/project/images/', '/projects/project-a/images')

answered Jan 17, 2016 at 10:21

Zohar Peled

82.9k11 gold badges80 silver badges134 bronze badges

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

1 Comment

Ana Ameer Over a year ago

This is exactly what I need! Thank you!

Collectives™ on Stack Overflow

Dynamically change values for SQL Server table?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related