title: MySQL phpMyAdmin error in a simple date query
body: <p>In MySQL using phpMyAdmin I am trying out this simple query to fetch rows that satisfy a certain date criteria: </p>
  
  <pre><code>select * 
  from student_invoice
  where date_generated &lt; '2012-01-01'
  </code></pre>
  
  <p>The date_generated is of date type. I get an error in phpMyAdmin that says: </p>
  
  <pre><code>ERROR: Unclosed quote @ 64 STR: '
  </code></pre>
  
  <p>I have closed all quotes so its not making sense. The phpMyAdmin version is 2.11.9.6</p>