PostgreSQL replace specific html element

Question

I´d like to change a HTML snippet stored in database.

Let's assume there is only one table called table with columns id and content. In content column are stored HTML snippets

It has this kind of format

<div class="header">etc etc </div>

<div class="content"> content </div>

<div class="footer"> footer </div>

(and possibly more complex html structure).

The goal is to replace the content div (so div with class content, there is guaranteed that there is just one div with this class identifier) from stored string with some text, for example "TEXT" using SQL on PostgreSQL.

So in this case the result would be

<div class="header">etc etc </div>

TEXT

<div class="footer"> footer </div>

Thank you

S-Man · Accepted Answer · 2020-11-19 12:24:49Z

1

I'd use REGEX_REPLACE() for this:

demo:db<>fiddle

SELECT
    REGEXP_REPLACE(html, '<div class="content">.*?</div>', 'MY TEXT')
FROM t

edited Nov 19, 2020 at 12:24

answered Nov 19, 2020 at 12:19

S-Man

24k9 gold badges51 silver badges78 bronze badges

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

1 Comment

Johnczek Over a year ago

Thanks for reply, it seems to work. The additional slash is a mistake, I´ve fixed that. Thanks

Collectives™ on Stack Overflow

PostgreSQL replace specific html element

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related