title: UPDATE string with an apostrophe in the string
body: <p>I am working on a C# windows form which is connected to MySQL and updates strings within the form. I have everything working properly except for a small issue. </p>
  
  <p>Say you want to update the "notes" field to read "The dog's bone", that apostrophe is causing the SQL query to end and cause an error. How can I get around this please?</p>
  
  <pre><code>UPDATE `database`
  SET `notes` = 'The dog's bone'
  WHERE `Pet` = 'Dog';
  </code></pre>
  
  <p>Thanks!</p>