wordpress - sql query - comments table - replace mutiple words

On wordpress 3.8

on comments table

What sql query will replace
word1 with word2  
word3 with word4
.
.
word99 with word100



P.S.

I have 10 questions, highest point level - open about sql queries

Soo, Lots of points for an sql guy
Matt_Walker01Asked:
Who is Participating?
 
ZberteocConnect With a Mentor Commented:
You can use nested REPLACE functions:
UPDATE your_table SET 
	your_field = REPLACE(...REPLACE(your_field, 'word1', 'word2'), 'word3', 'word4'),...'word99','word100')
WHERE <condition_here>

Open in new window

0
All Courses

From novice to tech pro — start learning today.