like

relationalai.semantics.std.strings

like(s: StringValue, pattern: StringValue) -> Expression

Check whether s matches the SQL LIKE pattern pattern.

Parameters

• s

  (StringValue) - The string to match against.

• pattern

  (StringValue) - The SQL LIKE pattern (% for wildcard, _ for single character).

Returns

• Expression - An Expression that evaluates to true if s matches the pattern.

Examples

Match strings using SQL LIKE patterns:

select(Brand.name).where(strings.like(Brand.name, r"Mc%"))
select(Brand.name).where(strings.like(Brand.name, r"%est%"))

Referenced By

RelationalAI Documentation
└──  Build With RelationalAI
    └──  Understand how PyRel works > Use advanced reasoning > Rules-based reasoning
        └──  Work with strings
            └──  Filter facts with text conditions