How to find and replace blocks of text (HTML code) in a MySQL database?

Question

PHP

There is a shitty WordPress site with about ~900 pages. Some of them have an HTML form (right in the body of the page). You need to replace it with the shortcode of the Contact Forms 7 plugin.
A normal request like

UPDATE wp_posts
SET post_content = REPLACE(post_content, 'найти', 'заменить на')
WHERE post_content LIKE '%найти%';

of course, it doesn't work, because these are blocks of HTML code with line breaks, formatting, etc. Is it possible to do something about this? Regular expressions (I don't know them) can help?

Answer 1

1. sql - select all pages from database
2. php foreach is all
3. php -regular check for the presence of a form
4. php -regular to replace
5. sql - update record in database

Answer 2

Weird. And what - formatting and line breaks in all forms are different? right here in each-each form is unique?