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

id|       body
-----------------------------------
1 | ... &lt;img src=test.jpg&gt; ... 
2 | ... &lt;img src=test2.jpg&gt; ... 
3 |... &lt;img src=tests3.jpg&gt; ....


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, $$&lt;img src=tests3.jpg&gt;$$, ' ') FROM table


But I couldn't do it dynamically.
regexp_replace() seems ideally suited

SELECT REXEXP_REPLACE(column, $$&lt;img src=[^&gt;]*&gt;$$, ' ','g') FROM table