How can I replace HTML line in MySQL?

Question

I need to replace an html code in multiple posts. This is the code I am using:

UPDATE wp_posts SET post_content = REPLACE(post_content, 'target="_top" class="text"') WHERE 'post_content'  = 'class="text"'

But I am getting an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE 'post_content' = 'class="text"'' at line 1

Is there any solution to make it work properly ?

how are you executing the sql?

Daniel A. White
– Daniel A. White

2012-08-31 19:06:08 +00:00
Commented Aug 31, 2012 at 19:06 — Daniel A. White
– Daniel A. White, Commented Aug 31, 2012 at 19:06

Niet the Dark Absol · Accepted Answer · 2012-08-31 19:06:17Z

3

REPLACE takes three arguments, you only gave two. You didn't tell it what to replace the matched text with.

answered Aug 31, 2012 at 19:06

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

Comments

Mike Brant · Accepted Answer · 2012-08-31 19:09:56Z

1

You need three arguments for replace, and you will also need to use LIKE in your WHERE clause or you won't get any matches. Finally you don't want single quotes around post_content in the WHERE clause. Either use backticks or nothing.

UPDATE wp_posts
SET post_content = REPLACE(post_content, 'class="text"', 'target="_top" class="text"')
WHERE post_content LIKE '%class="text"%'

answered Aug 31, 2012 at 19:09

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Comments

Kermit · Accepted Answer · 2012-08-31 19:08:38Z

1

Take a look at the manual for proper use of REPLACE. You need to provide 3 arguments:

REPLACE(str, from_str, to_str)

Returns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str.
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
        -> 'WwWwWw.mysql.com'

answered Aug 31, 2012 at 19:08

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Collectives™ on Stack Overflow

How can I replace HTML line in MySQL?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related