Postgresql: replace part of string on update

Question

I have 5000 plus records where I need to remove part of the value of a field

In all cases, the part I wish to remove is "Job Description - "

Hence update so that "Job Description - Doctor" becomes "Doctor"

So (I guess) I am looking to

UPDATE mytable 
    SET myfield = {some regex}

where myfield like '%Job Description - %'

Any advice would be much appreciated

Jake · Accepted Answer · 2017-02-17 07:03:03Z

18

The answer is as follows:

UPDATE mytable 
  SET myfield = REPLACE(myfield, 'Job Description - ','');

user330315

answered Feb 17, 2017 at 6:56

Jake

4,68810 gold badges44 silver badges89 bronze badges

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

1 Answer 1