Remove fragments in HTML tags

Remove fragments in HTML tags

Prepare ticket text for an archive without markup. Find rows containing fragments in angle brackets and remove every such fragment together with the brackets. Return ticket_id and the cleaned text as plain_body, ordered by ticket_id ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid