mysql数据库 如何批量清除 zblogphp文章内容超链接

数据库执行sql命令清楚文章内容里的超链接

update zbp_post set log_Content = replace(log_Content,substring(log_Content,locate("<a ", log_Content),locate(">", log_Content,locate("<a ", log_Content))+1-locate("<a ", log_Content)),"");