Thread: Global find/replace? SQL query? Need to replace common text/code.

Hello, I have about 80 products, each with its page's code in the Description section of the admin backend.

Now I need to change a hyperlink that appears around the same image on ever page.

How do I change that common code short of going to each and every page?

Much thanks,
Bryan

If I understand this exactly, you want to have a global find/replace on the product in your DB which contains a certain text? To find them, you can run a sql query and use a 'like' function (e.g. Select * from table where description like 'http' - this should return all products that have http on their descriptions).

UPDATE Product
SET Description = Replace(Cast(Description AS NVARCHAR(Max)),
'YOUR OLD TEXT GOES HERE',
'YOUR NEW TEXT GOES HERE')

This works good, it solves the common problem of not being aable to replace ntext data. It will find your old text in the descriptions and replace it with the new text you specify.

Thanks for the replies.

I want to be able to replace text or code. I also need to be able to do this in the Extension Data...or Summary.

I'll try the SQL and check back in.