Skip to main content

DB_Column.like

likepattern

Group: Logical

Documentation​

Checks for each element of the column if it matches an SQL-like pattern.

Arguments​

  • pattern: The pattern to match self against. If it is a column, the operation is performed pairwise between corresponding elements of self and that column. The pattern is an SQL-like pattern, where % matches any sequence of characters and _ matches any single character.

Examples​

Check if elements of a column start with 'F' and end with a dot.​

      import Standard.Examples

      example_contains = Examples.text_column_1.like "F%."