title: Doing a SQLite MATCH using only negated terms
body: <p>I recently found that this is impossible in SQLite:</p>
  
  <pre><code> SELECT * FROM fruit WHERE fruit MATCH '-apple'
  </code></pre>
  
  <p>Yet this is possible:</p>
  
  <pre><code> SELECT * FROM fruit WHERE fruit MATCH 'pear -apple'
  </code></pre>
  
  <p>I tried this using FTS3 and FTS4 with the same results. Why does match require at least one non-negated term? And how do I work around this limitation? I need to return all fruits that don't match "apple"...that's it. Any ideas?</p>