title: How Can I Search for Records That Have A Null/Empty Field Using CQL?
body: <p>How can I write a query to find all records in a table that have a null/empty field?  I tried tried the query below, but it doesn't return anything.</p>
  
  <pre><code>SELECT * FROM book WHERE author = 'null';
  </code></pre>