title: Why would rows match but not be changed with a mysql update statement?
body: <p>I'm used to MSSQL, not Mysql, so sorry for this probably stupid question. I'm trying update my password for a backup database I'm getting setup by running the following query:</p>
  
  <pre><code>update users set password = md5('pass') where username = 'admin'
  </code></pre>
  
  <p>When I run this it says</p>
  
  <blockquote>
    <p>Query OK, 0 rows affected (0.01 sec)
    Rows matched: 1  Changed: 0  Warnings: 0</p>
  </blockquote>
  
  <p>Why is a row matching but not changing?</p>