# SQL Predicates

> SQL language predicates are used in a `select` statement `where` clause to limit result set rows. The eXtremeSQL predicate operators are the following:

> between | Values between the specified bounds
> like, ilike | String values matching a specified pattern
> in | Values contained in a specified set
> exists | Value is present in a result set
> exact_match | exact match (Patricia trie)
> prefix_match | longest prefix match (Patricia trie)