mysql批量替换html特殊标签语法介绍（wordpress模板）

update wp_posts set post_content = replace(
  post_content,
  substring(
    post_content,
    locate('<p><a href=', post_content),
    locate('</a></p>', post_content) + LENGTH('</a></p>') - locate('<p><a href=', post_content)
  ),
  ''
);