title: Replace Existing String with New In MySql Table
body: <p>I have table like this :</p>
  
  <p><img src="https://i.stack.imgur.com/Sde08.jpg" alt="enter image description here"></p>
  
  <p>In that <code>order_address</code> field is there.</p>
  
  <p>In that I have stored details of buyer / user i.e. Name + address + City + Pin /Zip Code + State + Country + mobile.</p>
  
  <p>Between All that I have used <code>sep</code> as separator of each one.
  Now I want to replace all <code>sep</code> with some other character in whole table.</p>
  
  <p>Suppose I want to replace <code>sep</code> with <code>//</code> in whole table.</p>
  
  <p>So how to do that using query? I don't know about it so any suggestion for that.</p>