问题描述
我有以下查询，并收到以下错误消息:
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;
我正在尝试在我的wordpress数据库中查找简码并将其删除.有人知道哪里出问题了吗?非常感谢
I am trying to find the shortcode within my wordpress database and remove it. Does anyone know what is wrong? many thanks
推荐答案
为什么不使用"PHP中的数据库搜索和替换脚本"?您所要做的只是将其放置在根文件夹中，然后在浏览器中运行它. https://interconnectit.com/products/search-and-replace- for-wordpress-databases/
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.
这篇关于MySQL搜索和替换语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！