title: How to remove double quote character in MySQL
body: <p>I've been used <a href="https://stackoverflow.com/questions/5348153/using-substring-in-mysql-criteria">the solution</a>, but it cannot solved for special character.
  I've tried</p>
  
  <pre><code>SELECT address FROM myDatabase.users
  where substring(address,1,1) = '"';
  </code></pre>
  
  <p>What should I do to remove or change any special character or specific character in database like that??</p>
  
  <hr>
  
  <p>anyway, after I ask my friend, he show me that the error come from setting in mysql workbench, I should to unselect "Safe Updates" check box in Edit >> Preferences >> SQL Editor >> Query Editor. thanks for the answer.</p>