title: MySQL not updating row which clearly exists
body: <p>When I make an update query: </p>
  
  <pre><code>update sometable set somecolumn1='value' where somecolumn2 = 'value' 
  </code></pre>
  
  <p>in <code>phpMyAdmin</code> it says <code>0 rows affected. ( Query took 0.0048 sec )</code></p>
  
  <p>but when I do: </p>
  
  <pre><code>select * from sometable where somecolumn2 = 'value' 
  </code></pre>
  
  <p>a row is returned, meaning it does exist. Why isn't the row then getting updated? </p>