title: SELECT * FROM WHERE does not find all records
body: <p>When I type:</p>
  
  <pre><code>select * from 'saleslog' where 'Status' = 'Pending';
  </code></pre>
  
  <p>or</p>
  
  <pre><code>select * from 'saleslog' where 'Status' = "Pending";
  </code></pre>
  
  <p>or</p>
  
  <pre><code>select * from saleslog where Status = 'Pending';
  </code></pre>
  
  <p>despite the fact that there are hundreds of rows with "Pending" value in Status column I get only 3 records displayed. The same happens when I look for value other than "Pending".</p>
  
  <p>If however, I type:</p>
  
  <pre><code>select * from saleslog where status like "%Pending%";
  </code></pre>
  
  <p>then most if not all records are displayed. There are absolutely no spaces or any other characters in front and behind Pending value.</p>
  
  <p>I am wondering if table "saleslog" needs to be repaired and if so, how? I'm kind of new to SQL.</p>