title: How to replace SQL field value
body: <p>I really don't know exactly what to do, I'm a bit new to SQL. Should I use <code>substring</code> or <code>replace</code> in my case?</p>
  <p>I have a field in my DB called &quot;email&quot;, now I wanted to edited all email ending with &quot;email.com&quot; to &quot;email.org&quot;. What shall I do?</p>