The help page about the search feature is incomplete. Other info I've found about it:

random bits of info

reference

personal findings

Extra things that seem to work from the Whoosh search syntax: Things that work in unexpected ways: Things that don't work from the Whoosh syntax: