Find and Split string in PostgreSQL

Question

I have column in my table with data type varchar And that value is like a tag Example :

 <> e2=“69”  su=“58” fu=“55” <\>

I want search and find ‘su’ value and replace in that column

napentathol · Accepted Answer · 2018-08-29 18:59:45Z

1

In this case you will want to use something like

SELECT REGEXP_REPLACE(string, 'su="\d{2}"', 'su="value"')

answered Aug 29, 2018 at 18:59

napentathol

1,7532 gold badges14 silver badges15 bronze badges

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

1 Answer 1