Re: Search and Replace multiple values

[Barry Galbraith]

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.