SQL wildcard symbols for partial character comparisons
SQL supports the following wildcard symbols in the LIKE operator:
- % (percent sign)
- Represents zero, one, or more characters
- _ (underscore)
- Represents exactly one character
The query builder API does not support the use of SQL wildcard symbols in the startsWith or contains predicate methods. If you include wildcard symbols in the search-term parameter of either method, the query builder methods escape their special meaning by preceding them with a backslash (\).
