$sql
$sql : \Pop\Db\Sql
SQL object
SQL Where Predicate class
$sql : \Pop\Db\Sql
SQL object
__construct(\Pop\Db\Sql $sql) : \Pop\Db\Sql\Predicate
Constructor
Instantiate the predicate collection object.
\Pop\Db\Sql | $sql |
add(mixed $predicate) : \Pop\Db\Sql\Predicate
Add a predicate from a string
mixed | $predicate |
nest() : \Pop\Db\Sql\Predicate
Add a nested predicate
equalTo(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for =
string | $column | |
string | $value | |
string | $combine |
notEqualTo(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for !=
string | $column | |
string | $value | |
string | $combine |
greaterThan(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for >
string | $column | |
string | $value | |
string | $combine |
greaterThanOrEqualTo(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for >=
string | $column | |
string | $value | |
string | $combine |
lessThan(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for <
string | $column | |
string | $value | |
string | $combine |
lessThanOrEqualTo(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for <=
string | $column | |
string | $value | |
string | $combine |
like(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for LIKE
string | $column | |
string | $value | |
string | $combine |
notLike(string $column, string $value, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for NOT LIKE
string | $column | |
string | $value | |
string | $combine |
between(string $column, string $value1, string $value2, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for BETWEEN
string | $column | |
string | $value1 | |
string | $value2 | |
string | $combine |
notBetween(string $column, string $value1, string $value2, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for NOT BETWEEN
string | $column | |
string | $value1 | |
string | $value2 | |
string | $combine |
in(string $column, mixed $values, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for IN
string | $column | |
mixed | $values | |
string | $combine |
notIn(string $column, mixed $values, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for NOT IN
string | $column | |
mixed | $values | |
string | $combine |
isNull(string $column, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for IS NULL
string | $column | |
string | $combine |
isNotNull(string $column, string $combine = 'AND') : \Pop\Db\Sql\Predicate
Predicate for IS NOT NULL
string | $column | |
string | $combine |