I recently found that this is impossible in SQLite:

```
 SELECT * FROM fruit WHERE fruit MATCH '-apple'

```

Yet this is possible:

```
 SELECT * FROM fruit WHERE fruit MATCH 'pear -apple'

```

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?