Post by TheBedderPlace » Mon Oct 26, 2015 6:05 pm

Hi,

We have the same delivery information in each products description. The delivery times have recently changed so we need to change it a little.

Rather than editing each product one by one is there an SQL query that could be used to bulk edit the whole lot at once?
i.e change 'Next Working Day' to '3-5 Working Days'

Any help on this would be greatly appreciated as it could us save loads of time!

Thanks
Last edited by TheBedderPlace on Mon Oct 26, 2015 10:16 pm, edited 1 time in total.


Posts

Joined
Wed Aug 20, 2014 7:15 pm

Post by TheBedderPlace » Mon Oct 26, 2015 9:48 pm

Never worked with sql queries before but after a bit of googling i worked it out to be

UPDATE `oc_product_description`
SET `description` = REPLACE(`description`,'Next Working Day','2-5 Working Days')

Solved :)


Posts

Joined
Wed Aug 20, 2014 7:15 pm
Who is online

Users browsing this forum: No registered users and 17 guests