Parameters

Return Value

string
in(string $column, string|array(string) $values)

Returns the SQL to check if a value is one in a set of
given values.

.

in() accepts an arbitrary number of parameters. The first parameter
must always specify the value that should be matched against. Successive
must contain a logical expression or an array with logical expressions.
These expressions will be matched against the first parameter.

string
isNotNull(string $expression)

Parameters

Return Value

string
between(string $expression, string $value1, string $value2)

Returns SQL that checks if an expression evaluates to a value between
two values.

The parameter $expression is checked if it is between $value1 and $value2.

Note: There is a slight difference in the way BETWEEN works on some databases.
http://www.w3schools.com/sql/sql_between.asp. If you want complete database
independence you should avoid using between().