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