Inheritance diagram for Str:A character string expression.
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 StrTrait | |
| 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... | |
| 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 BaseConversionTrait | |
| 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... | |
| 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... | |
1.8.17
