From The Document Foundation Wiki
- Strings should be enclosed in single quotes.
- In the examples above, and in draft mode, enclosing quotes are not required. They will be added automatically after validation.
- In draft mode one can also use the wildcard % but it will automatically be replaced with * after validation.
- In SQL mode, only the % wildcard may be used.