title: Error with a change column mysql query
body: <p>what is wrong with this query?</p>
  
  <pre><code>ALTER TABLE test_table 
  CHANGE text_string text_string VARCHAR(255) 
      COLLATE utf8_unicode_ci NOT NULL 
      COMMENT 'hey here are mysql comments..' ;
  </code></pre>
  
  <p>in PHPMyAdmin it runs fine, but if i execute this query from my PHP class, it returns this:</p>
  
  <pre><code>error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&lt;br&gt;' at line 1
  </code></pre>
  
  <p>note there is a <code>&lt;br&gt;</code> tag in the mysql error, I assume its from mysql itself as I always use <code>&lt;br /&gt;</code> . I have searched through my code for a <code>&lt;br&gt;</code> too so its not me. Im probably just tired and thats in all mysql errors!</p>
  
  <p>I have been on this now for a while, so why does mysql not like this query? Fresh eyes much appreciated!</p>
  
  <hr>
  
  <p>PHP handler to run the generated query:</p>
  
  <pre><code>$q = isset($_POST['q']) ? base64_decode(($_POST['q'])): false;
  
  $db-&gt;q($q) or die("error: ".mysql_error());
  </code></pre>
  
  <p>yes, the base64_decode is working right.</p>
  
  <hr>
  
  <p><strong>$q output:</strong></p>
  
  <p>decoded query</p>
  
  <pre><code>ALTER TABLE sNOWsh_amb_nicks_1st_test_table CHANGE text_string text_string VARCHAR(255) collate utf8_unicode_ci NOT NULL COMMENT 'hey here are mysql comments..' ;
  </code></pre>