How to delete data inside tags?

Question

PHP

There are a lot of posts that have something like this:
< p>< span>%TEST% al %TEST2%< /span>< /p> and after that there is a lot of text
inside html placeholder tags
and that's what I need make a sql query so that this part <p>< span>%TEST% ald %TEST2%< /span>< /p> - disappears from all records where it is. How can this be done via mysql? Is this some kind of regular? Maybe someone has some examples.
Important: the highlighted part of ald can change (it can be adl, or anything else). So you need to somehow hook on <span> and %TEST% %TEST2%

Answer 1

Where do you get the $link variable from? From the air? Turn on errors in PHP and PHP itself will give you an answer, however, in English.

Answer 2

MySQL regular expressions