Character string expression manipulation.
|
| Str | concat (... $strings) |
| | Concatenate other strings. More...
|
| |
| Str | hex () |
| | Hex representation. More...
|
| |
| Predicate | isEmpty () |
| | Zero-length. More...
|
| |
| Num | length () |
| | Number of characters (not necessarily bytes). More...
|
| |
| Str | lower () |
| | Lowercase. More...
|
| |
| Str | ltrim (string $chars=null) |
| | See StrTrait::trim(). More...
|
| |
| Num | position (string $substring) |
| | Substring's position (1-based). More...
|
| |
| Str | replace (string $search, string $replace) |
| | String replacement. More...
|
| |
| Str | rtrim (string $chars=null) |
| | See StrTrait::trim(). More...
|
| |
| Num | size () |
| | Number of bytes (not necessarily characters). More...
|
| |
| Str | substr (int $start, int $length=null) |
| | Substring. More...
|
| |
| Num | toBase10 (int $from) |
| | Convert from an arbitrary base to base 10. More...
|
| |
| Str | trim (string $chars=null) |
| | Trims whitespace (or other things) from both ends of the string. More...
|
| |
| Str | upper () |
| | Uppercase. More...
|
| |
| Value | coalesce (array $values) |
| | COALESCE($this, ...$values) More...
|
| |
| 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...
|
| |
| 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...
|
| |
| Str | toBase (int $from, int $to) |
| | Convert between arbitrary bases. More...
|
| |
| Str | toBase16 (int $from=10) |
| | Convert from an arbitrary base to base 16. More...
|
| |
| Str | toBase2 (int $from=10) |
| | Convert from an arbitrary base to base 2. More...
|
| |
| Str | toBase8 (int $from=10) |
| | Convert from an arbitrary base to base 8. More...
|
| |