title: mysql: How can I remove character at start or end of field
body: <p>I have field that contains a comma-separated list. Some old records have a comma at the beginning or end of the field. I need to remove these extra commas.</p>
  
  <p>Example:</p>
  
  <p><code>,the,their,then</code> to <code>the,their,then</code></p>
  
  <p>or</p>
  
  <p><code>the,their,then,</code> to <code>the,their,then</code></p>
  
  <p>EDIT: I am looking for an UPDATE statement. I need to change the records.</p>