- '%' can be inserted into the query as a wild card, which matches any charactor string with any length.
- '%' will be automatically added at the beginning and the end of the keyword by the system.
- 'and' will be evaluated prior to 'or'. Add parenthesis at the
beginning or the end of the keywords appropriately to change the priority.