title: Updating String in PostgreSQL
body: <p>In a given database table "Animals",a column called 'anim_name" existed as shown in the picture below
  <a href="https://i.stack.imgur.com/gA8rB.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/gA8rB.jpg" alt="enter image description here"></a></p>
  
  <p>to update the anim_name so that there won't be a '-' . </p>
  
  <p>Example: </p>
  
  <pre><code>'TE-MAEWA 04000' should update as 'TE MAEWA 04000' 
  'TE-MAEWA 04354 CHAROLAIS CROSS' should update as 'TE MAEWA 04354 CHAROLAIS CROSS'
  </code></pre>
  
  <p>The following update statement is wrong</p>
  
  <pre><code> update animals 
      set anim_name = 'TE MAEWA%'
    where soc_code = 'AUDV' 
      and anim_name like 'TE-MAEWA%'
  </code></pre>
  
  <p>because this would update every animal name to 'TE MAEWA%'. what would be the right update statement. </p>