title: MySQL WHERE clause not working with strings
body: <p>I have one table with some email addresses. The address is of course a string, which I've set up on table creation as VARCHAR(100) DEFAULT NULL.</p>
  
  <p>Now, when I use:</p>
  
  <pre><code>SELECT * FROM emails;
  </code></pre>
  
  <p>It works fine, if I also select using ID's, it works fine</p>
  
  <pre><code>SELECT * FROM emails WHERE id = 1;
  </code></pre>
  
  <p>But if I try to find a particular email</p>
  
  <pre><code>SELECT * FROM emails WHERE address = 'email@host.com'
  </code></pre>
  
  <p>It simply doesn't work. It returns no rows matching this, but there <em>is</em> a row matching, because it appears on the <code>SELECT * FROM emails</code> query.</p>
  
  <p>What can be happening here? Why the WHERE clause is not working?</p>
  
  <p><strong>EDIT</strong>: The data came from the following import</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'c:/users/user/dev/mysql/emails.txt'
  INTO TABLE emails
  FIELDS terminated by ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  (address)
  </code></pre>