Inheritance diagram for Value:A typeless value expression, which can be cast to any type.
Additional Inherited Members | |
| Protected Properties inherited from Expression | |
| DB | $db |
| string | $expression |
| Public Static Methods inherited from Expression | |
| magic static self | factory (DB $db, string $expression) |
| Public Methods inherited from Expression | |
| __construct (DB $db, string $expression) | |
| string | __toString () |
| Public Methods inherited from ValueTrait | |
| Value | coalesce (array $values) |
COALESCE($this, ...$values) More... | |
| Public Methods inherited from AggregateTrait | |
| Num | avg () |
AVG($this) More... | |
| Num | avgDistinct () |
AVG(DISTINCT $this) More... | |
| Num | count () |
COUNT($this) More... | |
| Num | countDistinct () |
COUNT(DISTINCT $this) More... | |
| Str | groupConcat (string $delimiter=',') |
GROUP_CONCAT($this) using a delimiter. More... | |
| Num | max () |
MAX($this) More... | |
| Num | min () |
MIN($this) More... | |
| Num | sum () |
SUM($this) More... | |
| Num | sumDistinct () |
SUM(DISTINCT $this) More... | |
| Public Methods inherited from ComparisonTrait | |
| Predicate | is ($arg) |
| Null-safe type-strict equality. More... | |
| Predicate | isBetween ($min, $max) |
$this BETWEEN $min AND $max (inclusive) More... | |
| Predicate | isEqual ($arg) |
| See Predicate::match(). More... | |
| Predicate | isFalse () |
$this IS FALSE More... | |
| Predicate | isGt ($arg) |
$this > $arg, or driver-appropriate $this > ALL (SELECT ...) More... | |
| Predicate | isGtAny (Select $select) |
Driver-appropriate $this > ANY (SELECT ...) More... | |
| Predicate | isGte ($arg) |
$this >= $arg, or driver-appropriate $this >= ALL (SELECT ...) More... | |
| Predicate | isGteAny (Select $select) |
Driver-appropriate $this >= ANY (SELECT ...) More... | |
| Predicate | isLike (string $pattern) |
$this LIKE $pattern More... | |
| Predicate | isLt ($arg) |
$this < $arg, or driver-appropriate $this < ALL (SELECT ...) More... | |
| Predicate | isLtAny (Select $select) |
Driver-appropriate $this < ANY (SELECT ...) More... | |
| Predicate | isLte ($arg) |
$this <= $arg, or driver-appropriate $this <= ALL (SELECT ...) More... | |
| Predicate | isLteAny (Select $select) |
Driver-appropriate $this <= ANY (SELECT ...) More... | |
| Predicate | isNot ($arg) |
| Null-safe type-strict inequality. More... | |
| Predicate | isNotBetween ($min, $max) |
$this NOT BETWEEN $min AND $max (inclusive) More... | |
| Predicate | isNotEqual ($arg) |
$this <> $arg or $this NOT IN ($arg) More... | |
| Predicate | isNotLike (string $pattern) |
$this NOT LIKE $pattern More... | |
| Predicate | isNotNull () |
$this IS NOT NULL More... | |
| Predicate | isNotRegExp (string $pattern) |
$this NOT REGEXP $pattern More... | |
| Predicate | isNull () |
$this IS NULL More... | |
| Predicate | isRegExp (string $pattern) |
$this REGEXP $pattern More... | |
| Branch | switch (array $values=[]) |
CASE $this ... More... | |
| Public Methods inherited from DateTimeCastTrait | |
| DateTime | toDateTime () |
| Interpret the expression as a datetime. More... | |
| Public Methods inherited from NumCastFloatTrait | |
| Num | toFloat () |
| Casts the expression as a floating point number. More... | |
| Public Methods inherited from NumCastIntTrait | |
| Num | toInt () |
| Casts the expression as a signed integer. More... | |
| Public Methods inherited from StrCastTrait | |
| Str | toStr () |
| Casts the expression as a character string. More... | |
1.8.17
