SQL replace query

[parasite]

hi all,

 

I am attempting to run an SQL query to replace a URL in the products_description column of the products_description table. My SQL knowledge is poor at the best of times! Does anyone here know what query I should use or can point me in the direction of a good SQL resource?

 

Many Thanks,

Armin

[burt]

UPDATE `products_description` SET `products_description` = REPLACE(`products_description`, "OLD URL", "NEW URL");

 

Something like that - backup db first.