Red::ColumnMethods

Red::Column methods

method starts-with

method starts-with(
    Str(Any) $text
) returns Mu

Tests if that column value starts with a specific sub-string is usually translated for SQL as column like 'substr%'

method ends-with

method ends-with(
    Str(Any) $text
) returns Mu

Tests if that column value ends with a specific sub-string is usually translated for SQL as column like '%substr'

method contains

method contains(
    Str(Any) $text
) returns Mu

Tests if that column value contains a specific sub-string is usually translated for SQL as column like %'substr%'

method substr

method substr(
    $offset = Code.new,
    $size?
) returns Mu

Return a substring of the column value

method substr

method substr(
    $offset = Code.new,
    $size?
) returns Mu

Return a substring of the column value

method index

method index(
    $needle
) returns Mu

Return a index of the column value

method index

method index(
    $needle
) returns Mu

Return a index of the column value

method year

method year() returns Mu

Return the year from the date column

method month

method month() returns Mu

Return the month from the date column

method day

method day() returns Mu

Return the day from the date column

method yyyy-mm-dd

method yyyy-mm-dd() returns Mu

Return the date from a datetime, timestamp etc

method AT-KEY

method AT-KEY(
    $key where { ... }
) returns Mu

Return a value from a json hash key

method DELETE-KEY

method DELETE-KEY(
    $key where { ... }
) returns Mu

Delete and return a value from a json hash key

method AT-POS

method AT-POS(
    $key where { ... }
) returns Mu

Returns a value from a json array index