Re: Search and Replace multiple values
What I would do is something like this
UPDATE wp_content set post_content = replace(post_content,'red','black');
UPDATE wp_content set post_content = replace(post_content,'blue','black');
UPDATE wp_content set post_content = replace(post_content,'...','black');
UPDATE wp_content set post_content = replace(post_content,'...','black');
Run as many times as there are colours to replace.
Does that work for you?
Good luck,
Barry.
Subject
Written By
Posted
February 08, 2014 08:18PM
Re: Search and Replace multiple values
February 08, 2014 09:36PM
February 09, 2014 09:43PM
February 10, 2014 05:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.