title: Mysql update query to remove the single quotes from name field
body: <p>I have set of results in my table which contain the character <code>'</code>. These characters are contained in a person's name. For example, in my <strong>Persons</strong> table some names are stored as,</p>
  
  <pre><code>Bill' Murray
  Andy' Griffin
  </code></pre>
  
  <p>I can find such names from my table using the query,</p>
  
  <pre><code>SELECT * FROM Persons WHERE first_name LIKE '%\''
  </code></pre>
  
  <p>I need to update the information of these people by removing the <code>'</code>. So after updating, I need the values as,</p>
  
  <pre><code>Bill Murray
  Andy Griffin
  </code></pre>