title: MySQL: Update finds matches, but does not make changes. Why?
body: <p><strong>Configuration:</strong><br>
  WAMP Server on WinServer 2008 R2, MySQL v5.1.36<br>
  I'm running my query directly in the MySQL Terminal.<br>
  The table being targeted is an <em>InnoDB</em> table, and the field being set is a lookup field against a string FK.</p>
  
  <p><strong>Challenge:</strong><br>
  The query results say that there are a bunch of matches, but that no changes are being made.<br>
  What am I missing?</p>
  
  <p>BTW: My experience level with MySQL Terminal is quite limited. In fact, I'm really only using it now because PhpMyAdmin chokes on the query (time exceeded throwing PMA session error).</p>
  
  <p><strong>Code:</strong><br>
  The SQL I'm using is extremely basic:</p>
  
  <pre><code>UPDATE `my_table_name` 
  SET `vendor_type` = 'master'
  WHERE `data_source` = 'Group One'
  </code></pre>
  
  <p>Here are the results of the query:</p>
  
  <blockquote>
    <p>Query OK, 0 Rows affected (15.94 sec)<br>
    Rows matched: 149947  Changed: 0 Warnings: 0</p>
  </blockquote>
  
  <p>As you can see, there are almost 150k records that <em>"should"</em> be getting updated, but aren't.</p>