title: MySQL "unknown column"
body: <p>My database table has columns email, username and password. I'm trying to insert these test values into them, but the query seems to be interpreting the value for the test email in a strange way. 
  What's wrong with this query?</p>
  
  <pre><code>mysql&gt; INSERT INTO `tbl_user`
      -&gt; (`email`, `username`, `password`)
      -&gt; VALUES
      -&gt; (`test1@notanaddress.com`, `Test_User_One`, MD5(`test1`)),
      -&gt; (`test2@notanaddress.com`, `Test_User_Two`, MD5(`test2`))
      -&gt; ;
  ERROR 1054 (42S22): Unknown column 'test1@notanaddress.com' in 'field list'
  </code></pre>