title: SQL: Update column value conditioned on same column value
body: <p>On a SQLite database something I thought was very simple doesn't work at least under my conditions.</p>
  
  <p>I have one column with names and some name contains apostrophe (<code>'</code>), which I want to remove. I know all names which contains an apostrophe, so I am not trying to query for apostrophes. I am doing something much simpler:</p>
  
  <pre><code>UPDATE table SET column_name="name surname1 surname2" WHERE column_name="name surname1'surname2";
  </code></pre>
  
  <p>which doesn't return what I expect. It doesn't produce an error but it doesn't modify any record.</p>
  
  <p>SQL doesn't like reflexivity? </p>