Replace in base on a mask?

Question

PHP

I am doing the following query in mysql:

UPDATE table SET text = replace(text,'предмет','<a href="/predmet">предмет</a>');

there is a replacement: item with < a href = "predmet "> item a>
please tell me how to correctly compose this request so that there are replacements, including:
item - < a href = "/predmet"> item a>
item - < a href = "/predmet">of item a>
item - < a href = "/predmet">item a>

Answer 1

Use either Like or RegExp operator in sql query.
If you will process on the php side, use preg_replace