title: escaping special character in mysql statements while using UPDATE
body: <p>I am trying to update a field using </p>
  
  <pre><code>UPDATE table set field='some_variable' where id=1;
  </code></pre>
  
  <p>The problem here is that the some_variable comtains data with multiple special characters in it. so I am not able to use 'some_variable' or "some_variable" as it breaks and fails when it encounters the first same character(' or "). How can I overcome this?</p>
  
  <p>Thanks.
  Mike</p>