MySQL search and replace syntax error

Question

I have the following query and get the below error message:

update `wp_posts` set  `post_excerpt` = replace( `post_excerpt`, "[av_font_icon icon='ue82d' font='entypo-fontello' size='14px' position='left' color='' custom_class=''][/av_font_icon]", '') where instr( `post_excerpt`, "[av_font_icon icon='ue82d' font='entypo-fontello' size='14px' position='left' color='' custom_class=''][/av_font_icon]") > 0;

#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 '"[av_font_icon icon='ue82d' font='entypo-fontello' size='14px' position='left' c' at line 1

I am trying to find the shortcode within my wordpress database and remove it. Does anyone know what is wrong? many thanks

IN your error message I see 3 quotes at the beginning,make sure they are double quotes — Mihai
– Mihai, Commented Sep 15, 2015 at 18:44

galfaro · Accepted Answer · 2015-09-16 01:48:17Z

1

Why don't you use the "Database Search And Replace Script In PHP"? All you have to do is place it in the root folder and run it in your browser. https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

That's what I use and have never had a problem. Just make sure to make a back up just in case.

Run a search for the short code and replace it with an empty field.

edited Sep 16, 2015 at 1:48

answered Sep 15, 2015 at 22:29

galfaro

2082 silver badges11 bronze badges

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

Comments

Robert Hartshorn · Accepted Answer · 2015-09-15 17:35:48Z

0

You should escape the single quotes in the string you are matching, using ''

answered Sep 15, 2015 at 17:35

Robert Hartshorn

16610 bronze badges

Collectives™ on Stack Overflow

MySQL search and replace syntax error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related