MySQL REPLACE doesn't work

Question

I use this to replace \" with " :

UPDATE wp_posts SET post_content = REPLACE (post_content, '\"', '"')

That query returns 0 row(s) affected and nothing happens.

What is wrong this this query?

bobwienholt · Accepted Answer · 2012-09-22 16:09:05Z

5

You need to escape your backslash:

UPDATE wp_posts SET post_content = REPLACE (post_content, '\\"', '"')

answered Sep 22, 2012 at 16:09

bobwienholt

17.6k3 gold badges43 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jakobandersen · Accepted Answer · 2012-09-22 16:09:53Z

1

The backslash charecter is escape character in MySQL so you need to escape it itself like this:

UPDATE wp_posts SET post_content = REPLACE(post_content, '\\"', '"')

answered Sep 22, 2012 at 16:09

jakobandersen

1,4099 silver badges10 bronze badges

faq · Accepted Answer · 2012-09-22 16:10:15Z

1

use:

REPLACE(`post_content`, '\\"', '"')

answered Sep 22, 2012 at 16:10

faq

3,1465 gold badges29 silver badges37 bronze badges