OK here is the situation.

I relocated a PrestaShop ecommerce website.
Everything works great except for one thing.

Each product within the database has a long description field and usually that description field allows for insertion of an image via the WYSIWYG editor.

So in the new website installation the images are referenced as
http://www.olddomain.com/img/cms/image.png

whereas i need to change them all to
http://www.newdomain.com/img/cms/image.png

Of course I could go through each image and do it manually but with over 600 products that would be a massive time drain.

So.... I am looking for a way to update my database using phpMyAdmin SQL update query.

If it helps;
the database is called PS_MYSHOP1
the table containing the description is called PS_PRODUCT_LANG
and the description field itself is called DESCRIPTION

Any help from SQL gurus welcomed

Bueller? Bueller? Bueller?

UPDATE table SET column = REPLACE(column, 'olddomain', 'newdomain');

UPDATE table SET column = REPLACE(column, 'olddomain', 'newdomain');

Thanks Chris.

So the sql query should look like this?

UPDATE ps_product_lang SET description = REPLACE(description, 'olddomain' , 'newdomain')

Should be Ok at that and you could always add a WHERE clause to test it on a subset of records before running it against all records.

Originally Posted by chrishirst

Should be Ok at that and you could always add a WHERE clause to test it on a subset of records before running it against all records.

Sounds good. Could you show me an example of what you mean by the WHERE clause?

http://www.w3schools.com/sql/sql_where.asp

Got it. thanks.