Replace column with dynamic value

Question

There's a column in my database which has got this kind of value:

id|       body
-----------------------------------
1 | ... <img src=test.jpg> ... 
2 | ... <img src=test2.jpg> ... 
3 |... <img src=tests3.jpg> ....

Basically, after the = sign I can have anything. And I would like to change it for nothing.

I know if it was a static value I could use:

SELECT REPLACE(column, $$<img src=tests3.jpg>$$, ' ') FROM table

But I couldn't do it dynamically.

Jasen · Accepted Answer · 2018-05-04 04:39:53Z

0

regexp_replace() seems ideally suited

SELECT REXEXP_REPLACE(column, $$<img src=[^>]*>$$, ' ','g') FROM table

answered May 4, 2018 at 4:39

Jasen

3,6761 gold badge15 silver badges17 bronze badges

1 Answer 1