title: How to skip blank data in MySQL?
body: <p>I wanted to skip blank data in MySQL.</p>
  
  <p>My sample query is:</p>
  
  <pre><code>SELECT id, name, date from sample where name IS NOT NULL;
  </code></pre>
  
  <p>Sample table:</p>
  
  <pre><code>id     name         date
  1                  24-04-2012
  2      abc         23-04-2012
  </code></pre>
  
  <p>Now if I fire above query, it gives me both record but I want to skip data which is stored as blank i.e. There is nothing(<strong>not even NULL</strong>)?</p>
  
  <p>So how can I skip 1st record? What should be my query?</p>
  
  <p><strong>So how to skip blank data in MySQL?</strong>      </p>
  
  <p>Please guide me.</p>