Update with regexp_replace replaces match with literal regex pattern

Question

I am trying to update a column in MariaDB using regexp_replace. I've tested this out in this fiddle and it works just fine, however when I update and export the table, it seems that the match is replaced by the literal regex pattern - href="#h_$1" .

This is my query:

UPDATE blog_posts
SET blog_content = regexp_replace(blog_content, 'href="[^#"]+#h_(.+)"', 'href="#h_$1"');

Did anyone encounter this before and if yes how can I solve it?

MySQL doesn't support back-references in regexp_replace(). — Barmar
– Barmar, Commented Jul 11, 2022 at 19:52

Bernd Buffen · Accepted Answer · 2022-07-11 20:02:40Z

1

You can use \\1 to select the pattern. try:

UPDATE blog_posts
SET blog_content = regexp_replace(blog_content, 'href="[^#"]+#h_(.+)"', 'href="#h_\\1"');

see manual: https://mariadb.com/kb/en/regexp_replace/

answered Jul 11, 2022 at 20:02

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update with regexp_replace replaces match with literal regex pattern

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related