title: Postgresql: replace part of string on update
body: <p>I have 5000 plus records where I need to remove part of the value of a field</p>
  
  <p>In all cases, the part I wish to remove is "Job Description - "</p>
  
  <p>Hence update so that "Job Description - Doctor" becomes "Doctor" </p>
  
  <p>So (I guess) I am looking to</p>
  
  <pre><code>UPDATE mytable 
      SET myfield = {some regex} 
  </code></pre>
  
  <p>where myfield like '%Job Description - %'</p>
  
  <p>Any advice would be much appreciated</p>