Regular expression in mysql on update?

Question

MySQL

There is a request like this

UPDATE products SET full_description = REPLACE(full_description, REGEXP "<h2.+>", "<h2>");

Help me spell it right. The error is here:

REGEXP "<h2.+>"

mysql version 5.1.73

Answer 1

mysql 8.0+? then

UPDATE products SET full_description = REGEXP_REPLACE(full_description, "<h2.+>", "<h2>");

https://dev.mysql.com/doc/refman/8.0/en/regexp.htm...

Answer 2

REGEXP_REPLACE

UPDATE products SET full_description = REGEXP_REPLACE(full_description, '<h2.+>', '<h2>');

Answer 3

Old server mysql version 5.1.73