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...
|
|