Search Queries

One or more condition statements you can use to refine the data returned by the request. Only records that satisfy filtering conditions are returned. If there are multiple conditions, a record must satisfy all conditions for a match.

To use wildcards with the LIKE, ILIKE NOT_LIKE OR NOT_ILIKE filters, use the % symbol to match any string. This allows you to perform more flexible and broad searches for text data.

• % represents a wildcard to match zero or more characters
• _ (underscore) represents a wildcard match for a single character