I have column with text where I need to change characters! For example
So I need to replace � with character D. I try next but I get error:invalid regular expression: quantifier operand invalid
update tableT pp set descript=(select regexp_replace(descript,'�', 'D')
FROM
tableT kk where pp.id=kk.id) ;
update tableT pp
set descript = (select replace(descript, '�', 'D') from tableT where id = pp.id)
Why don't use replace?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With