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
whereas i need to change them all to
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
Please login or register to view this content. Registration is FREE
"Order a PEBBLE Smart Watch for Bluetooth connection to your iPhone or Android" - 100% Waterproof - 7+ days Battery Charge - High Res Outdoor Readable - Vibrating Alert - Incoming Caller ID